Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 May 2022

Top 3 Topics with Most Views

How to divide the 2 datatables from one sheet to different sheet made by @bhanupriya.cb with 45 views.

Comparing two excel columns and updating corresponding values made by @praveenchintu374 with 43 views.

How to Use Element Exists and Excel Application Scope In parallel, for Excels with Pop-up Macro made by @Archie with 43 views.

Top 3 Topics with Most Replies

Compare two datatables and get unique value from dt1 made by @Sahil_Garg1 with 19 replies.

How to divide the 2 datatables from one sheet to different sheet made by @bhanupriya.cb with 18 replies.

Problem with Send Hotkey made by @comdatos with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 52 posts!

@muhammedyuzuak made 28 posts!

@ppr made 20 posts!

Top 3 Most Liked Posts

This post made by @Praga_Vivek received 2 likes!

UiPath Forms Tutorial - Check / Uncheck All Select Boxes

Hi, Recently, I came across a customer requirement where we need to check / uncheck all select boxes in an UiPath form. I am able to come up with a working solution after doing some R&D. I wanted to share the solution for the benefit of others. Below are the steps to build Check/Uncheck All option for select boxes in an UiPath form. Create a form and add a Select box and Button component Add few values to the select boxes and rename the button component like below [formDesign] Edit t…

This post made by @joergen_moeller received 2 likes!

How to learn c#

Hi @Aleem_Khan, There are many tutorials online for C#. Keep in mind that the default language for UiPath processes are VB, because of this a majority of the documentation and syntax shared on the forums are VB. However, I believe a more advanced knowledge in C# will help you regardless as you will develop a broader understanding of the possibilities with C# and .Net. If you want advanced examples on working with Excel in Uipath you can check out this link: For a general approach to C# you c…

This post made by @jack.chan received 2 likes!

Click into Details for SAP VA01 Create Sales Order

@jmcheong7 theres a tableRow attribute in the selector [image] 0= 1st row, 1 = second row and so on… you can make it dynamic by using an integer variable e.g. [image] then update tableRow attribute in selector to this tableRow='{{tableRow}}'

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

Save subfolder name to variable

@Jack_Seven_Offsuit You can try as below to get all the folders in the path Declare a String variable let’s say as ListofFolders Use Assign activity and write as below ListofFolders = Directory.GetDirectories(“C:\users\00001”) Use For Each activity and change the TypeArgument to String in properties Inside For Each you can keep a write line message and write as Item.ToString which will give you the all the each directory it contains Hope this may help you Thanks

This solution provided by @Praga_Vivek received 1 likes!

Select all checkbox UiPath.Forms.Activities

Hi @Stephanie_Rimel / @jeevith , This can be implemented using advanced logic. Please find the attached project containing a working example. Sample Project.zip (14.1 KB) I have also created a tutorial for this feature Thanks, Praga

This solution provided by @Yoichi received 1 likes!

What I need to fill for Spreadsheet?

Hi, Can you try Spreadsheet as the following? [image] 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.