Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 May 2023

Top 3 Topics with Most Views

CLI for interacting with UiPath services made by @thschmitt with 64 views.

What are the reasons for choosing UiPath for RPA instead of using JavaScript or Python? made by @indiedev91 with 56 views.

Extract the multi row value in excel file made by @Le_Vo_Tien_Phat_KHCM with 53 views.

Top 3 Topics with Most Replies

Extract the multi row value in excel file made by @Le_Vo_Tien_Phat_KHCM with 12 replies.

Regex activity issue made by @BlueBird1 with 11 replies.

How to copy column data from excel and paste in a web browser in single line format made by @Naman_Arora with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 20 posts!

@Anil_G made 17 posts!

@vishal.kp made 13 posts!

Top 3 Most Liked Posts

This post made by @thschmitt received 6 likes!

CLI for interacting with UiPath services

Command Line Interface (CLI) for interacting with UiPath Services uipathcli provides a unified command line interface for accessing UiPath resources. You can use the CLI to execute commands from a terminal, either interactively or automated through scripts. The CLI makes it easy to get started using UiPath Service APIs and allows you to set up resources and automate small tasks. uipathcli works on all major platforms (Windows, Linux, MacOS) and architectures (x86/x64 and ARM). Getting Starte…

This post made by @vishal.kp received 2 likes!

How enter yesterday date example today is 04/05/2023 I have to enter 04/04/2023. What is the expression can we use?

Hi @Zuber_Shaikh , Datetime.Now.adddays(-1).tostring("dd/MM/yyyy") Regards,

This post made by @Umadevi_Sanjeevi received 2 likes!

How enter yesterday date example today is 04/05/2023 I have to enter 04/04/2023. What is the expression can we use?

Hi @Zuber_Shaikh , Can you confirm which value you have to enter. 04/04/2023 or 03/05/2023. Input = 04/05/2023 Get yesterday date Now.AddDays(-1).ToString("dd/MM/yyyy") Output is 03/05/2023 Get Last month yesterday date from the current date Now.AddMonths(-1).AddDays(-1).ToString("dd/MM/yyyy") Output: 03/04/2023 Thanks!

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

Linq query to remove a particular string from a particular column

Hi @taruna.mehra Give a try with the following [image] In the invoke code use this dtInput.AsEnumerable().ToList().ForEach(Sub(r) r("Column name -session Id")= r("Column name -session Id").ToString().Trim().Replace("#ADA#", String.Empty)) Make sure to replace the exact column name within the double quotes Regards!

This solution provided by @AmlanKiranPatel received 1 likes!

Published Automation Not Showing in Uipath Assistant

Hi @vishal.kp , It’s Solved. Actually, I was Publishing it to “Orchestrator Tenant Process Feed” Instead of “Orchestrator Personal WorkSpace Feed”.(Just a silly mistake that takes me 3Hr to Solve. Ha Ha )

This solution provided by @arjunshenoy received 1 likes!

Get value from a List of Dictionary based on a Key value

Hi @Himanshu_Punj You can use the following query: dictList.Where(Function(dict) dict("Age").ToString() = "25").Select(Function(dict) dict("Name").ToString()).FirstOrDefault() Hope this helps, Best Regards.

---

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.