Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 February 2023

Top 3 Topics with Most Views

Try catch 자체 오류 made by @youngchang with 44 views.

Identify if there is any duplicate values in excel column made by @nir.kail with 44 views.

Download Folder from Share point using Microsoft Office 365 Package made by @lakshman with 42 views.

Top 3 Topics with Most Replies

After open UI path studio it can open studio x made by @Shubham_Bidwai with 19 replies.

Identify if there is any duplicate values in excel column made by @nir.kail with 15 replies.

Message: "Click 'Download': Multiple similar matches found made by @hiennguyen with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@Sudharsan_Ka made 23 posts!

@fernando_zuluaga made 23 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 4 likes!

How to get the value count in particular Row

@404_Error Use for loop on the datatable and then use this inside to get the count Total = currentrow.Itemarray.Count(function(x) x.ToString.Equals("True")) Atlernately on excel you can use countif formula and use autofill range activity Cheers

This post made by @jeevith received 2 likes!

Invoke Python Method: Pipe is broken

Hi @amithvs, I have wasted a lot of hours as I said before trying to understand Pipe is broken error and I have chosen to move away from the Python Scope Activity. My other two fallbacks are Invoke PowerShell Activity and Start Process Activity. Sadly the Invoke PowerShell activity is currently broken in Windows projects (UiPath Community 2022.12 Release - #41 by jeevith) So the Start Process activity is the only option I can see working using standard UiPath activities. It has a way to call a…

This post made by @Rutva_patel1 received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Congratulations and Happy 5th Anniversary UiPath Academy! I appreciate that so much quality content is free and products can be tested completely free to test them. My first experience with UiPath Academy was in 2021. UiPath academy is my best UiPath platform, it helped my at the beginning of everything in UiPath and RPA, this also helps a lot my team mates to reach their projects with the best practices and techniques. Regards, Rutva

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 4 likes!

How to get the value count in particular Row

@404_Error Use for loop on the datatable and then use this inside to get the count Total = currentrow.Itemarray.Count(function(x) x.ToString.Equals("True")) Atlernately on excel you can use countif formula and use autofill range activity Cheers

This solution provided by @Anil_G received 2 likes!

Convert response body into excel

@Bhushan_Nagaonkar Its a json …do first use deserialize json and select type as jarray as I see a jarray first Then use jarr(0)("ClientNumber").ToString to get the clientnumber and so on Which can then be wrriten to datatable using add datarow Cheers

This solution provided by @Gokul_Jayakumar received 1 likes!

How to increase the numbers in a column

Hello @pprin001 Refer to this Xaml file you may Get Some idea Forum_NumberAutoFill.zip (143.2 KB) [image] [image] Use Excel Modern Actvity. If You are classic user, Enable activity vy following these steps: Click Actvity pannel> Click Filter> Enablke the Show modern option. [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.