Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 June 2022

Top 3 Topics with Most Views

How to create a dynamic delay? made by @educadoinstitute with 52 views.

文字の置換方法について made by @moom with 43 views.

Data extraction process of the central bank according to the date and currency type received with the mail body made by @ertan_ay1 with 40 views.

Top 3 Topics with Most Replies

Data extraction process of the central bank according to the date and currency type received with the mail body made by @ertan_ay1 with 30 replies.

How to use the condition in web automation? made by @HeartCatcher with 18 replies.

Data scrapping handling made by @taruna.mehra with 15 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 44 posts!

@Nithinkrishna made 28 posts!

@ertan_ay1 made 24 posts!

Top 3 Most Liked Posts

This post made by @lavmang received 2 likes!

Event Data Filters for Integration Service released!

Great. Now integration service is finally useful! Would be great if there would be a possibility to “queue” the triggered process, in our use case we would like to start it only after work hours so that the production license is available for work-hour scheduled processes.

This post made by @ankit.jain2 received 2 likes!

Email Headers Issue

Hello All, i am facing issue in mail.headers attribute , when i am separately running the process its working fine . In the watch panel Mail.headers showing 9 properties but when i am invoking the same workflow its showing only 2 attribute i.e.’ uid , message id. Dependency and uipath reinstalled already

This post made by @muhammedyuzuak received 2 likes!

Data extraction process of the central bank according to the date and currency type received with the mail body

Hi @ertan_ay1, Can you try going directly to the date range instead of selecting a date on this page? Then you can pull this table with datascraping and filter the rows you want. I am sharing an example, use the format in this example. https://www.tcmb.gov.tr/kurlar/[year][month]/[day][month][year].xml https://www.tcmb.gov.tr/kurlar/202206/14062022.xml Additionally, you can use the API. I am sharing the link so you can follow it. https://evds2.tcmb.gov.tr/help/videos/EVDS_Web_Servis_Kull…

Top 3 Most Liked Solutions

This solution provided by @Rahul_Unnikrishnan received 1 likes!

Orchestrator keeps signing me out of Unattended robot

Hello @hurmet.noka So whenever you are trying to Run the process are you getting this error or only during debug? Please make sure you have properly allocated the unattended license. [UiPath - How to connect UiPath to Orchestrator|Run Process,Jobs & Triggers|UiPath Licensing]

This solution provided by @jack.chan received 1 likes!

How to set red colour to complete row text when column "Results" contains failed?

yes but its troublesome, if you want to highlight whole row, do this instead add below code to vba.txt Function highlightCellRedWholeRow(rowNumber As Integer, sheetName As String) ActiveWorkbook.Sheets(sheetName).Activate Rows(CStr(rowNumber) & ":" & CStr(rowNumber)).Select With Selection.Font .Color = vbRed End With ActiveWorkbook.Save End Function use invoke VBA in excel application scope, set function name = highlightCellRedWholeRow, entryMethodParameters = {…

This solution provided by @Veera_Raj received 1 likes!

How to extract "specific data rows" from excel

table= table.select(“‘columnname’=‘LT’”).copytodatatable() or use filter table activity and configure your column name and value [filtertable]

---

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.