Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 May 2021

Top 3 Topics with Most Views

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 35 views.

Filter table by 2 Columns made by @markosc with 35 views.

Retrieving Conversation ID from mail box made by @rakshitha.shetty with 34 views.

Top 3 Topics with Most Replies

Publish error: Regex.Match non declared made by @Danny_Gi with 18 replies.

Move PDFs based on Name in specific Folders made by @Yudhisteer_Chintaram1 with 17 replies.

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 12 replies.

Top 3 Users Who Posted The Most

@Yudhisteer_Chintaram1 made 19 posts!

@josephatomwanzia made 17 posts!

@Adrian_Star made 16 posts!

Top 3 Most Liked Posts

This post made by @AndersJensen received 3 likes!

Filter data By Strikethrough In Excel?

Hey @Aaron_Ko For sure. I’ve created a simple VBA script for you, which does the job (checks if there is a Strikethrough). If yes, write “1” in the next column. We invoke it with an “Invoke VBA” activity inside an “Excel Application Scope” activity. Everything is attached. The simple Excel dataset (attached as Book1.xlsx) [image] The VBA code to invoke (attached as StrikeThrough.txt) Sub StrikeThrough() For n = 1 To Rows.Count If Range("A" + CStr(n)).Font.StrikeThrough Then Range("B…

This post made by @Steven_McKeering received 3 likes!

Regex for date

Hi A full list of your expected date formats is needed to build a robust Regex pattern. In the meantime, try this pattern:

This post made by @ppr received 2 likes!

Manually creating a TransactionItem/QueueItem w/o an Orchestrator queue

the prepared Dictionary has to be assigned on YourTransactionItemVar.SpecificContent Property

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Linq Query, Please Help!

@kantheshm give a try on following prepare an empty datatable with build datatable reflecting the target datacolumn strucutre: Col1 – Col2 - Col3 Variable: dtResult then use an assign activity left side: dtResult right side: (From d in dtData.AsEnumerable Group d by k1=d(“Col3”).toString.Trim,k2=d(“Col4”).toString.Trim into grp=Group Let s = grp.Sum(Function (x) CInt(x(“Col2”).toString.Trim)) Ler ra = new Object(){k1,s,k2} Select dtResult.Rows.Add(ra)).CopyToDataTable Also have a loo…

This solution provided by @AndersJensen received 1 likes!

Difficulty with modern folders

Hey @tainan.ramos Creating unattended robots in the new Modern Folder Orchestrator environment was the question I got the single-most. I’ve created this “get started” guide Feedback is very welcome. [🤖 Unattended Robots in UiPath Orchestrator (Full Tutorial)]

This solution provided by @Hiba_B received 1 likes!

Write full Date Format in Excel column

Hi @Yudhisteer_Chintaram1 ! Here is a suggestion: Date_conversion.xaml (9.7 KB) Beware, there is a strange date format at the end. I took care of it in the code through Try Catch but I wanted to let you know if it’s a forbidden/forgotten date format: [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.