Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 August 2021

Top 3 Topics with Most Views

キーで一致する値を取得したい made by @HANAKO with 28 views.

Bring next row to current row made by @aqiff with 28 views.

Best Practices for Web browser based automation made by @Debartha_Mitra_DE with 26 views.

Top 3 Topics with Most Replies

How can we get multiple matches value from string and store in a variable from regex made by @naim1000 with 17 replies.

Extract Link from Email body, Please help made by @Hurmet_Noka with 15 replies.

Merging two column made by @HeartCatcher with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 30 posts!

@lakshman made 21 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @sonaliaggarwal47 received 2 likes!

OneDrive QUESTION AUTOMATION - STUDIO

Hi @Atejera, Refer below links on how to setup office 365: [How to Setup and use Microsoft Office 365 with UiPath - Full Tutorial] https://docs.uipath.com/activities/docs/microsoft-office-365-scope And below link talks about all the operations you can perform for onedrive. https://docs.uipath.com/activities/docs/office365-files Regards Sonali

This post made by @sonaliaggarwal47 received 2 likes!

Reading a particular worksheet and invoke a certain workflow?

Hi @Kakooza-Allan-Klaus, I see you want to use 1 workflow only for Shell and Total however want to run part of logic conditionally. So when you are calling that workflow, how about passing sheet name as argument in that workflow and within that workflow, use a if-else block to drive changes to the sale logic based on sheet name this workflow was called. And when you are calling that workflow its inside a loop for reading worksheets one by one. Regards Sonali

This post made by @Gresilda_Balla received 2 likes!

Excel automation problem

Hi @Rakesh_Tiwari, I am sending you a short code that I think may help you. BlankProcess9.zip (37.3 KB)

Top 3 Most Liked Solutions

This solution provided by @sonaliaggarwal47 received 2 likes!

Reading a particular worksheet and invoke a certain workflow?

Hi @Kakooza-Allan-Klaus, I see you want to use 1 workflow only for Shell and Total however want to run part of logic conditionally. So when you are calling that workflow, how about passing sheet name as argument in that workflow and within that workflow, use a if-else block to drive changes to the sale logic based on sheet name this workflow was called. And when you are calling that workflow its inside a loop for reading worksheets one by one. Regards Sonali

This solution provided by @Yoichi received 1 likes!

キーで一致する値を取得したい

こんにちは エラー対応を除けば条件分岐は不要と思います。 イメージとしては以下の様になると思います。 [img20210825-3] データ１のRobotIDの中に、データ２のRobotIDが無いものがあれば、それの対応が必要になるかと思います。

This solution provided by @prasath17 received 1 likes!

Extract Link from Email body, Please help

Please show us what you tried and what did not work?? Please see below… [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.