Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 July 2023

Top 3 Topics with Most Views

Edge Extension not working - Could not communicate made by @Daniel_H-E with 251 views.

The robots couldn't communicate with Private mode of MS Edge browser made by @Mohammed_Bakr with 98 views.

🎯 UiPath Tutorial: Using the Pick Activity made by @ManFrancko with 53 views.

Top 3 Topics with Most Replies

3 Excel Reading made by @Gokul_Murali with 43 replies.

Unable to read unread mail made by @Mathkar_kunal with 25 replies.

Write Cell: Object reference not set to an instance of an object. Error made by @HENG_JUN_YING_AARON with 23 replies.

Top 3 Users Who Posted The Most

@mkankatala made 68 posts!

@Anil_G made 57 posts!

@lrtetala made 52 posts!

Top 3 Most Liked Posts

This post made by @Vikas_M received 3 likes!

Managing Data Table columns

Hey @Luis_Fernando , If you want to add only specified columns to Orchestrator then follow below steps Input datatable snapshot [image] Filtered Datatable snapshot (I removed AGE and SALARY columns) [image] Below is the Output of Filter Datatable [image] After filtering you can add the filtered Datatable to "Bulk Add Queue Items " Below is the Workflow Snapshot [image] Hope it helps You! Happy Automation!

This post made by @Mohammed_Bakr received 2 likes!

The robots couldn't communicate with Private mode of MS Edge browser

Hi after the last update of MS Edge, there is an issue with the extension of UiPath… the extension is installed and enabled but still, the robot is not able to communicate with the browser in Private mode… I tried to: disable and enable the extension. reinstall the extensions uninstall and reinstall the studio but unfortunately same issue … after a lot of investigation, I found that when the robot is opening Edge in normal mode there is an application called (Chrome Native Messaging Hos…

This post made by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

This solution provided by @pravallikapaluri received 1 likes!

Activities in version 2023

Hi @Pratik_Chaudhari1 Install the UiPath.excel.Activities [image] Hope it helps!!

This solution provided by @Yoichi received 1 likes!

Regex match question

Hi, According to your pattern, you want to match not only MM/dd/yyyy style but also MMMM/dd/yyyy style (such as July 25,2023) don’t you? If so, the following pattern will work. System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Statement\s+(Issued\s+)?)(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?|Sep(tember)?|Oct(ober)?|Nov(ember)?|Dec(ember)?)\s?\d+,?\d+|(\d{1,2}/\d{1,2}/\d{2,4}|\d{1,2}-(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?…

---

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.