Forum Engagement Daily Reports

[system]

Daily Forum Report | 27 July 2023

Top 3 Topics with Most Views

How do I count the number of rows with same variable? made by @helpplease with 58 views.

Column not found made by @helpplease with 53 views.

Different date format made by @helpplease with 53 views.

Top 3 Topics with Most Replies

Compare two sheets and change color in both or any one of sheets made by @Bhushan_Nagaonkar with 30 replies.

How to insert images into excel cells made by @alexis.mendoza with 30 replies.

Need to find index of array value in text file made by @Anil_Rajavarapu with 29 replies.

Top 3 Users Who Posted The Most

@mkankatala made 67 posts!

@lrtetala made 58 posts!

@vrdabberu made 50 posts!

Top 3 Most Liked Posts

This post made by @helpplease received 3 likes!

What exactly are special keys?

Thank you all for the explanations! I really appreciate them

This post made by @brian.oberman received 2 likes!

Change Scheduled Delivery of Reports to be globally and centrally set up and managed

Today, you can schedule delivery of reports via email in Insights. However, ONLY the person/user that set up the schedule and see/change their own schedules. This is a problem. First, if the person that set up the report delivery leaves your organization, you cannot change/update/view the report without UiPath assistance. (Per UiPath documentation: " Schedules are user-specific and can only be viewed by the user that created them in the Schedule/Alert Settings section." Second, it creates th…

This post made by @Felix_Rech1 received 2 likes!

Add Collection argument to 'Add Log fields' Activity

Hey UiPath Team, please consider adding a new input argument to the ‘Add Log Fields’ activity that allows users to hand in a collection Object (dictionary) as an alternative to adding the fields manually one by one, similar to how the ‘Add Queue Item’ activity allows users to supply a variable/argument of type ‘Dictionary(String,Object)’ instead of adding the required fields manually (ItemInformation vs. ItemInformationCollection). This is currently not possible with the ‘Add log Fields’ activ…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

How to saperate json

@Mathkar_kunal , Apologies as I could not get the separate term intially in your Query. The concentration was more towards the last line of the query. Even for the Expected Results provided by you, we could use the Same Expression : To retrieve results other than 1322 : jArr1 = JArray.FromObject(jArr.Where(Function(x)Not x("testExecKey").toString.Equals("TEST81313-1322"))) To retrieve results with 1322 : jArr2 = JArray.FromObject(jArr.Where(Function(x)x("testExecKey").toString.Equals("TES…

This solution provided by @pravallikapaluri received 1 likes!

Read every PDF files with OCR

Hi @Temuulen_Buyangerel [image] [image] Hope it helps!!

This solution provided by @lrtetala received 1 likes!

Round off to a decimal number

Hi @adishjain Math.Ceiling(Var1 * Math.Pow(10, Round)) / Math.Pow(10, Round) [image]

---

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.