Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 October 2021

Top 3 Topics with Most Views

setAsset activity clears the description of existing asset made by @dennis.werner1 with 39 views.

How to implement RPA & best practice? made by @Jon_G with 34 views.

Get Full text error When running workflow made by @SH_94 with 30 views.

Top 3 Topics with Most Replies

Excel操作が保存されない made by @lukatopdesrlat with 10 replies.

setAsset activity clears the description of existing asset made by @dennis.werner1 with 8 replies.

Cannot convert Excel Value to System.Int32 made by @m.jazib with 8 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 24 posts!

@Nithinkrishna made 10 posts!

@rahulsharma made 10 posts!

Top 3 Most Liked Posts

This post made by @dennis.werner1 received 2 likes!

setAsset activity clears the description of existing asset

Simply put, setAsset activity clears the description of existing asset. It should only change the value of an existing asset.

This post made by @Archie received 1 likes!

Asking for a better way of Dividing Datable and Looping in them

First of all, I am sorry for I am new at Uipath and is doing the everything in a long way. Currently, I have a filtered Datatable that contains a column(Currency) which contains either “Foreign” or “Local”. I need to filtered this filtered Datatable again by “Foreign” and “Local” rows(Two DTs now) then do a for each for both of them. Excluding this step, I already did two for each loops, and I think that doing it will mess up my workflow more. Is there a better way of dividing/filtering a Datat…

This post made by @Palaniyappan received 1 likes!

Asking for a better way of Dividing Datable and Looping in them

Hi @Archie We can split the datatable into two dt like this For rows containing only Foreign Dt1 = Maindt.AsEnumerable().Where(Function(a) a.Field(of String)(“yourcolumnname”).ToString.Contains(“Foreign”)).CopyToDatatable() For rows containing only Local Dt2 = Maindt.AsEnumerable().Where(Function(a) a.Field(of String)(“yourcolumnname”).ToString.Contains(“Local”)).CopyToDatatable() This will Dt1 and Dt2 with which you can now use a for each loop based on your process Where Dt1 and Dt2 are …

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Asking for a better way of Dividing Datable and Looping in them

I hope now i understood your issue. Yes you can just go with only one foreach please… Don’t even split the DT (which you did with linq previously) From the master DT, iterate through ForeachRow Inside that add an if block to find foriegn or other currency, based on that you can add respective currency activities in true & others in else block. This way will have one foreach with actual business logic for both currency types inside based on a condition. Thanks #nK

This solution provided by @Palaniyappan received 1 likes!

How to search name of file into folder which is variable

Hi Welcome to uipath forum Use a assign activity like this to get the last saved file with your new file name as expected in the folder [image] Cheers @rutuja.y

This solution provided by @adarsh_kotagiri received 1 likes!

How to update status based on row values in excel

Hii Hey chek this file below. Here i have created process for this problem , please let me know if you face any problem with this while executing. Main.xaml (11.3 KB) FILE_1.xlsx (8.6 KB) File_2.xlsx (8.0 KB)

---

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.