Forum Engagement Daily Reports

[system]

Daily Forum Report | 07 February 2023

Top 3 Topics with Most Views

How to install UiPath studio for latest version 2022.10 (I am using Flex plan) made by @BNK with 42 views.

ReFrameworkでインプットファイルがない場合の処理 made by @111860 with 38 views.

How to get dynamic cell range made by @Sai.Srinivas with 36 views.

Top 3 Topics with Most Replies

Why retry is not working in system Exception in Reframework in uipath? made by @Prabin_Chand with 19 replies.

How to run java based web application in locked screen? made by @Prabin_Chand with 19 replies.

Add prefix to whole row made by @neha.kumarief868 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Sudharsan_Ka made 30 posts!

@rikulsilva made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to filter value using query instead of filter data table

dtResult = From d in YourDataTabeVar.AsEnumerable Let si = d.Item("Index").ToString.Trim Where {"0","1.0"}.Any(Function (x) si.StartsWith(x)) Select r = d).CopyToDataTable Handling empty results: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

This post made by @rikulsilva received 2 likes!

How to filter value using query instead of filter data table

Hi, you can use linq for this yourDt = yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0")).CopyToDataTable But, before make assignment, make sure that the DT has least one row with your condition or it will be throw a exception in CopyDataTable method. put in if condition yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0")).Any Or you can directly put in assign using if your dt = if(yourDt.AsEnumerable.Where(Function(x) x.Item("Index")…

This post made by @rikulsilva received 2 likes!

How to create an action for x amount of times a task is performed

You can use loop activities to processes your tasks. Inside your loop, put some validation before start the next one. For example, check if login time out occurs, if so, you call other workflow just for login. Then your process continues without break. If you need more robust solution with retry mechanism, processes task individually and so on the better choice is ReFramework If you perform simple task, you can create additional step for check login. Specially create a workflow only for lo…

Top 3 Most Liked Solutions

This solution provided by @rikulsilva received 1 likes!

How to filter value using query instead of filter data table

Yes, it is. Just add “or” condition yourDt = yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0") or x.Item("Index").ToString.StartsWith("1.0")).CopyToDataTable

This solution provided by @Anil_G received 1 likes!

For each excel Row How do I message box counting out the numbers?

@oscar.o Then use fa filter datatable and filter the required row with 0 and then use filtereddt.rowcount and in message box write "0 is repeated " + filtereddt.rowcount.tostring Or create a integer variable and initialize it with 0 …then in the then condition use counter = counter+1 in assign and get the count and outside the loop use Msg box with "0 is repeated " + counter.tostring Hope this helps Cheers

This solution provided by @supermanPunch received 1 likes!

Error "End of expression expected" on Type Into activity

Hi @Dea_Pahumi , Could you try changing the Expression to the below : if(String.IsNullOrWhiteSpace(in_Address1),"",in_Address1) This part should be handled when you enabled the Property EmptyField [image] Let us know if this does not work as Expected and describe what happens.

---

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.