Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 September 2023

Top 3 Topics with Most Views

In Chrome and Edge v117 the Active Accessibility support is broken for IFRAMEs and PDFs made by @Luiza_Surdu-Bob with 107 views.

Extracting Post code from address made by @duaine.b with 40 views.

Error appear regarding use excel file made by @Nur_Amin with 39 views.

Top 3 Topics with Most Replies

Pick out unique email addresses from 2 columns and paste the unique email addresses in the BCC field of send smtp activity made by @ayushi_jain3 with 20 replies.

Regex to find first word that contains number made by @Suastrian_Dika with 15 replies.

Addition not working made by @Kamalesh_Chunekar with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 57 posts!

@Anil_G made 33 posts!

@postwick made 28 posts!

Top 3 Most Liked Posts

This post made by @raghu30691 received 3 likes!

Monthly Forum Rewards - August 2023

Hearty Congratulations Forum Leaders… @Anil_G , @Shiva_Nikhil Cheers

This post made by @Anil_G received 3 likes!

Need to capture value from this complex JSON

@c3f1e68294fdcf4a1f0a817ca first use a deserialize json activity and then from output use for for loop jobj("users")(0)("memberships").Cast(Of JObject) and inside loop use currentJObject("status").ToString currentJObject("permission_profile")("id").ToString currentJObject("permission_profile")("name").ToString Implementation [image] output [image] Hope this helps cheers

This post made by @mukeshkala received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

The UiPath emoji is awesome

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 3 likes!

Need to capture value from this complex JSON

@c3f1e68294fdcf4a1f0a817ca first use a deserialize json activity and then from output use for for loop jobj("users")(0)("memberships").Cast(Of JObject) and inside loop use currentJObject("status").ToString currentJObject("permission_profile")("id").ToString currentJObject("permission_profile")("name").ToString Implementation [image] output [image] Hope this helps cheers

This solution provided by @Anil_G received 2 likes!

Lookup data table not configured correctly

@E.T.S If you need the whole row use thsi dt.AsEnumerable.Where(function(x) Regex.Replace(x(0).ToString,"(\r?\n)*","").ToLower.Contains(Regex.Replace(YourStringVariable,"(\r?\n)*","").ToLower)).FirstOrDefault And if you need it as datatable and all the matched rows if there are multiple…then bettern first check if any thing is matching using if and then use copyto datatable To check matched dt.AsEnumerable.Where(function(x) Regex.Replace(x(0).ToString,"(\r?\n)*","").ToLower.Contains(Regex.Re…

This solution provided by @Gokul_Jayakumar received 1 likes!

Transpose excel data

@suraj.l Refer to this Xaml file you may get some idea. Transpose.xaml (11.4 KB) [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.