Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 August 2023

Top 3 Topics with Most Views

How to spilt the dynamic string? made by @Gowthaman_Gajakutti with 55 views.

Extract Data Table not change values made by @yorman2330 with 51 views.

Help me to spilt Company name, Job title and Experience date and Store them in different variable in Uipath made by @Gowthaman_Gajakutti with 46 views.

Top 3 Topics with Most Replies

Help me to spilt Company name, Job title and Experience date and Store them in different variable in Uipath made by @Gowthaman_Gajakutti with 21 replies.

Able to read range workbook without error? made by @winnie_toh with 16 replies.

What is the method for moving cell values one by one from a sheet to cells on another sheet in Excel? made by @22222222asas with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 69 posts!

@Nguyen_Van_Luong1 made 37 posts!

@rlgandu made 32 posts!

Top 3 Most Liked Posts

This post made by @s.bruce received 2 likes!

Reusable components with libraries is much more difficult than Invoke Workflow

Hi Jason, Quick example - a developer builds a XAML which logs into a web portal, that login XAML is included in a ‘reusable components’ library which is then published to Orchestrator. You have 10 processes which all need to log into that web portal, but one day the third-party changes the login page and all ten processes break. If you had to copy and paste XAMLs between projects, that’s ten change requests, ten code branches, ten tests, ten approvals/pull requests, ten merges, ten new packag…

This post made by @Praveen_Mudhiraj received 2 likes!

How to remove time stamp from date

H! @satish.rathi59 instead of doing all ,simply use this expression Convert.ToDateTime(“05/21/2023 00:00:00”).ToString(“MM/dd/yyyy”) for the reference check below screenshot! [image]

This post made by @manojj.yadav received 2 likes!

Clicking a specific button when there's 5 same buttons

Couldn’t solve this issue with anchor either. The anchor is highlighted correctly but the target is clicked at a different window. Finally, I figured our that I can also close window by right clicking the bottom tabs (which are unique). So, I’m just gonna use it. [image] Thanks for responding!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Error: "Value for property is not a valid XML syntax."

@Carla_Munoz replace & with & str.Replace("&","&") or you can even use this System.Net.WebUtility.HtmlEncode("str") cheers

This solution provided by @Yoichi received 1 likes!

Cannot assign multiple string-type variables to a value from Excel using String.Format

Hi, Can you try to modify the following red arrow bracket to curly bracket? [image] Regards,

This solution provided by @Yoichi received 1 likes!

Able to read range workbook without error?

Hi, For now, can you try it to put Shortcut activity to send ESC before ReadRange? OR, in many case, it’s unnecessary to use shortcut. I guess you tried to get Sheet name before ReadRange. However we might be able to get each sheet name using ForEachExcelsheet or Classic Get Workbook Sheets activity. So, first, can you try to remove shortcut and set sheet name statically, then check if solve this issue. If it’s solved, try to get sheet name dynamically. Regards,

---

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.