Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 October 2021

Top 3 Topics with Most Views

How to Match my Regex Expression to link in Mail Body which is behind a click here button made by @vedant1 with 29 views.

Office 365 scope - Method not Found : "Void Microsoft.Graph.GraphServiceClient..ctor" made by @jhivesh.subron with 29 views.

How to get Latest datetime from data table made by @Vivek_Kumar4 with 26 views.

Top 3 Topics with Most Replies

How to get the last column header and the data of last row value from the excel sheet made by @Subha_Sundara_moorthi with 9 replies.

Send SMTP Mail Message: No such host is known made by @slimshadysingaporean with 8 replies.

How to Match my Regex Expression to link in Mail Body which is behind a click here button made by @vedant1 with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 30 posts!

@rahulsharma made 19 posts!

@ppr made 6 posts!

Top 3 Most Liked Posts

This post made by @rahulsharma received 2 likes!

How to remove Duplicate row Based on "person number" from Two different data table While looping through

you can use a VB script also to delete it. Attached the script in the code in new sequence, you can use that. Make sure you do the necessary changes required for running the macro. You need to update the below setting in Excel Settings [image] Steps: [image] File: FilterForum.zip (23.8 KB) Hope this should help you resolve your query. If so, mark a post as solution to close the thread

This post made by @Subha_Sundara_moorthi received 1 likes!

Mail.subject.contains doesn't auto-complete

Thanks!! Solved

This post made by @rahulsharma received 1 likes!

Mail.subject.contains doesn't auto-complete

Welcome to the UiPath Community @Subha_Sundara_moorthi! .Contains will always return a boolean value, it means that statement is true or false I assume you are trying to read subject and if ur contains Welcome word then printing it, right? Use a if condition, in the condition mention that same condition you wrote, just remove the .ToString from end. and in then block, write item.Subject Make sure you have the for loop property set correctly. The argument should be of Mail.Message type as s…

Top 3 Most Liked Solutions

This solution provided by @rahulsharma received 2 likes!

How to remove Duplicate row Based on "person number" from Two different data table While looping through

you can use a VB script also to delete it. Attached the script in the code in new sequence, you can use that. Make sure you do the necessary changes required for running the macro. You need to update the below setting in Excel Settings [image] Steps: [image] File: FilterForum.zip (23.8 KB) Hope this should help you resolve your query. If so, mark a post as solution to close the thread

This solution provided by @Palaniyappan received 1 likes!

Is this possible with UiPath community?

Hi Welcome to UiPath forum Let’s go one by one Yes we can use excel based activities and csv activities to read xlsx and csv files https://docs.uipath.com/releasenotes/docs/uipath-excel-activities https://docs.uipath.com/activities/docs/read-csv-file This can be fine with for each row activity https://docs.uipath.com/activities/docs/for-each-row These two steps can be done with TYPE INTO activity where mention like this CurrentRow(“yourcolumnname”).ToString Make sure you have k…

This solution provided by @Palaniyappan received 1 likes!

Getting error in outlook app

Hi Restart your machine and give a try again from UiPath studio And make sure outlook status is connected and online You can check that May be manually by opening outlook and at the right bottom we can see that Cheers @HeartCatcher

---

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.