Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 February 2025

Top 3 Topics with Most Views

An invalid character was found in the mail header: ',' made by @SSD with 25 views.

Hyperlinks not displaying in email made by @AA_queen427 with 20 views.

I am looking for use cases for all the domains of a manufacturing company on the applicability of RPA using UIpath made by @Suryanarayana_Murthy_Atre with 15 views.

Top 3 Topics with Most Replies

UiPath Extension Firefox made by @rpa_jasindo with 15 replies.

Hyperlinks not displaying in email made by @AA_queen427 with 12 replies.

An invalid character was found in the mail header: ',' made by @SSD with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@ashokkarale made 17 posts!

@AJ_Ask made 8 posts!

Top 3 Most Liked Posts

This post made by @singh_sumit received 2 likes!

Excel Pivot Table - Syntax for Field

Hey @AJ_Ask yes this could be the method but suppose if after N100 in the near future the data is got updated in 101 than it colud be a problem so @VanjaV make it more dynamic , cheers

This post made by @rpa_jasindo received 1 likes!

UiPath Extension Firefox

Is there anyone else who has the same error as me? I have updated to the latest version of Firefox, but it still shows the old version. I have updated UiPath Studio and reinstalled the Firefox extension. the extension still doesn’t want to communicate [image]

This post made by @AJ_Ask received 1 likes!

Excel Pivot Table - Syntax for Field

Hi @VanjaV In the field “NameofYourColumn” You just have to mention in double quotes name of the column. Hope this helps

Top 3 Most Liked Solutions

This solution provided by @AJ_Ask received 1 likes!

Excel Pivot Table - Syntax for Field

Hi @VanjaV You have to mention the range in source. Excel.Sheet(“Tabelle1”).Range(“C6:N100”) like this so that all the column names will appear. You can click on plus symbol to configure it, it will give you options. Hope this helps:)

This solution provided by @Manisha_Ravindra received 1 likes!

Extract date from filepath

@Nisha_K21 You can use regex to get date System.Text.RegularExpressions.Regex.Match(“TestData\monday04/02/2025.xlsx”, “\d{2}/\d{2}/\d{4}”).Value

This solution provided by @Manisha_Ravindra received 1 likes!

Remove duplicate rows from DT

Hi @Steven_ds_55 to remove duplicate rows from datatable use this: dt = dt.DefaultView.ToTable(True) True : ensures only distinct rows remain

---

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.