Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 January 2023

Top 3 Topics with Most Views

Project build: Generating synthetic test data (project) Add data row error made by @bruce.switzer with 77 views.

Need to Change Date Format from string to Date made by @manojmanu.rpa with 50 views.

How to compare the 2 excel sheets made by @Manoj_sreekanth with 46 views.

Top 3 Topics with Most Replies

PDF fields not recognizing made by @pravin_bindage with 19 replies.

How to get Excel window to foreground to send key strokes? made by @Prabin_Chand with 18 replies.

ダウンロード待機アクティビティに、『 次の拡張子の一時ファイルを無視:』が表示されない made by @masaaki.kasahara with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@Yoichi made 32 posts!

@rohin_Kumar made 19 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Need to Change Date Format from string to Date

In addition to: In general we would recommend to use ParseExact for converting the string into a dateTime Afterwards we can reformat as needed DateTime.ParseExact(YourInputString, YourFormat, System.Globalization.CultureInfo.InvariantCulture) Format parts (in/out) are as: [grafik] [grafik] Still we would recommend to check if the Time part is really breaking Month / year in the Position Kindly note: Friday 20th Jan 2022 does not exist, it was a Thursday so parsing this date will fail […

This post made by @Anil_G received 2 likes!

S108 Exception Based Query

@Harsha_S1 Please search for the activity for each row in Datatable… else change the type argument to datarow in the current for each… or write dt_ReadRange.AsEnumerable and give type argument as datarow hope this helps cheers

This post made by @Steyn_Muller1 received 2 likes!

Assign Data Service Entities separately to text fields in UiPath Apps

Thank you so much! It works!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

S108 Exception Based Query

@Harsha_S1 Please search for the activity for each row in Datatable… else change the type argument to datarow in the current for each… or write dt_ReadRange.AsEnumerable and give type argument as datarow hope this helps cheers

This solution provided by @indra received 1 likes!

Regex extractor not working with alternative anchors (word a OR word b)

@NielsF Welcome to UiPath community You can use this Regex Refer this to use regex in assign activity

This solution provided by @prasadprathmeshambika received 1 likes!

ERROR - The given key was not present in the dictionary

This kind of error mostly occurred when ,key value not present in config file and you r trying to call from workflow. eg. Config(“XYZ”).To String but XYZ key not present in config file.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.