Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 March 2023

Top 3 Topics with Most Views

How to download folder from google drive? made by @Tuannna1 with 87 views.

Read Table from PDF and Regex made by @bryant.macciano with 44 views.

'The Operation has timed out' error where the user tries to install package made by @feedrpa with 44 views.

Top 3 Topics with Most Replies

Deleting the Complete current row at the end made by @karthik_kulkarni1 with 17 replies.

How to download folder from google drive? made by @Tuannna1 with 16 replies.

Error After Update : Excel File cannot be overwritten made by @Vaishnav_Tej with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 88 posts!

@ABHIMANYU_THITE1 made 39 posts!

@raja.arslankhan made 19 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 4 likes!

How to apply multiple subject Filters in get outlook mail message

Hi @Ishan_Shelke Please try this: "@SQL=urn:schemas:httpmail:subject like '%MARCICOIMPPAID%' OR urn:schemas:httpmail:subject like '%MARICOIMPLCPAID'" Edit the quotations according to the syntax: "@SQL=""urn:schemas:httpmail:subject"" like '%MARCICOIMPPAID%' OR ""urn:schemas:httpmail:subject"" like '%MARICOIMPLCPAID%'" Hope this helps, Best Regards.

This post made by @Manish540 received 4 likes!

Data table column to list with no duplication

Hi @Hazem_Saleh , We can have C# linq’s in the Invoke Code activity as shown below, companyNames(List of String) = dt1.AsEnumerable().Select(ra => ra.Field<String>("COMPANYNAME")).Distinct<String>().ToList<String>(); We have to set the language to CSharp in Invoke Code activity property section as per below screenshot, [image] Arguments:- [image] Hope this may help you

This post made by @Manish540 received 3 likes!

For each row excel and when row have "Keyword" i want duplicated that row

Hi @Phunya , Check this below workflow attached, Uipath_DuplicateRowBasedOnKeyword.xaml (12.7 KB) [image] Hope this may help you

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 4 likes!

How to apply multiple subject Filters in get outlook mail message

Hi @Ishan_Shelke Please try this: "@SQL=urn:schemas:httpmail:subject like '%MARCICOIMPPAID%' OR urn:schemas:httpmail:subject like '%MARICOIMPLCPAID'" Edit the quotations according to the syntax: "@SQL=""urn:schemas:httpmail:subject"" like '%MARCICOIMPPAID%' OR ""urn:schemas:httpmail:subject"" like '%MARICOIMPLCPAID%'" Hope this helps, Best Regards.

This solution provided by @Manish540 received 4 likes!

Data table column to list with no duplication

Hi @Hazem_Saleh , We can have C# linq’s in the Invoke Code activity as shown below, companyNames(List of String) = dt1.AsEnumerable().Select(ra => ra.Field<String>("COMPANYNAME")).Distinct<String>().ToList<String>(); We have to set the language to CSharp in Invoke Code activity property section as per below screenshot, [image] Arguments:- [image] Hope this may help you

This solution provided by @Chirag_Shetty_Divakar received 3 likes!

For each row excel and when row have "Keyword" i want duplicated that row

Hey @Phunya [image] ExcelTable.zip (9.5 KB) Hope this helps Cheers.

---

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.