Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 March 2024

Top 3 Topics with Most Views

Can't open saved msg files made by @b.forbes with 58 views.

Can not assign made by @dipon1112000 with 49 views.

How to fetch queue data base on timestamp? made by @Sanket_Shinde1 with 40 views.

Top 3 Topics with Most Replies

How to fetch queue data base on timestamp? made by @Sanket_Shinde1 with 16 replies.

Can't open saved msg files made by @b.forbes with 15 replies.

I have to get each network nodes global title number range using regular expression made by @shaik.muktharvalli1 with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 24 posts!

@Parvathy made 20 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Write cell issue if no data

Hi, As there is no row in “Type of sample” column, lastrow variable will be -1 and it causes this exception. How about set “First empty row”? [image] Regards,

This post made by @mkankatala received 2 likes!

Write cell issue if no data

Hi @Happydayyy I have modified the Workflow for this, → insert the Write cell activity and give the below expression in What to write field, "='MU-bias (Within Range)'!T2" Check the below workflow for better understanding, [image] Main MU-bias (combined count (mainsheet).xaml (65.1 KB) Output: [image] Hope it helps!!

This post made by @Happydayyy received 2 likes!

Write cell issue if no data

thanks you so much. the issue is fixed!!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

Whats the Difference Between uipathActivites

Hi @devasaiprasad_K dt.columnscount: This property is used with UiPath Database activities like the “Execute Query” activity. It’s accessed directly as a property of the DataTable variable. It returns an integer representing the number of columns in the DataTable. dt.columns.Count: This property is used with standard DataTable operations in UiPath, such as manipulating DataTables using VB.NET. It’s accessed through the Columns property of the DataTable variable, which returns a collectio…

This solution provided by @Biswajeet_kumar received 2 likes!

Getting issue while Substracting extracted dates

Hi @madhavraichur25 Welcome to the community! This can be achieved using an assign instead of three with following steps: create a variable named No_Of_days as Int64 by selecting browse for types. In the value use this expression DateDiff(DateInterval.Day,CDate(now.ToString(“MM/dd/yyyy”)),Cdate(DateTime.ParseExact(your_date_String_Var.Trim,“dd/MM/yy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”))) Cheers! Biswajeet Kumar

This solution provided by @Vinit_Mhatre received 2 likes!

How to generate random password without using Custom Activity?

Hi @Random_Bot , Try with below, hope its help you. char as string = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" randomtext as string = New String(Enumerable.Repeat(characters, 9).Select(Function(s) s((New Random()).Next(s.Length))).ToArray()) output as string = String.Format("{0}@{1}", System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(randomText), New Random().Next(10000).ToString("D4")) [image] Regards, Vinit Mhatre

---

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.