Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 August 2022

Top 3 Topics with Most Views

Combine Duplicate row value into Single row made by @agathiyanv with 52 views.

Scheduling calendar and License utilization made by @Natalino_Mantoan with 47 views.

Select Current Month from a Drop Down Menu made by @Farah_halawani with 45 views.

Top 3 Topics with Most Replies

Select Current Month from a Drop Down Menu made by @Farah_halawani with 24 replies.

For each row - read only last 5 numeric characters made by @andrew.haworth with 19 replies.

Maintenance mode via Swagger authentication made by @Snowman with 18 replies.

Top 3 Users Who Posted The Most

@marian.platonov made 31 posts!

@ppr made 30 posts!

@Sanjit_Pal made 20 posts!

Top 3 Most Liked Posts

This post made by @Natalino_Mantoan received 6 likes!

Scheduling calendar and License utilization

Hello everyone, I would like to ask if there is a way to view all the schedules present on the tenant and the status of license occupations via monitoring, insights, or any other way. The main goal is to understand if a machine is overloaded or, on the other hand, is often free so as to better manage schedules or consider buying new licenses. I have already tried to look in Insights if information on schedules could be retrieved, but it does not seem to be possible. Also, in the Monitoring se…

This post made by @Sanjit_Pal received 4 likes!

Import Datatable From Word Document To Excel File

UiPath provides us the flexibility to export the data from the word document to excel file, here one more exciting way to achieve the result. You can create a .bat file using the below code Sub ImportWordTable(wdFileName) Dim wdDoc As Object Dim tableNo As Integer 'table number in Word Dim iRow As Long 'row index in Excel Dim iCol As Integer 'column index in Excel Dim resultRow As Long 'from which row result should be written Dim tableStart As Integer Dim tableTot As Integer On Error Resume…

This post made by @ppr received 3 likes!

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints Perf…

Top 3 Most Liked Solutions

This solution provided by @ankit.saraf received 2 likes!

Data Service: Query Entity Records Best Practice

It really depends on what you are trying to achieve with your process and how you are using the entities. The typical suggestion will be to use Query activity in the process to fetch the latest data from entities when you run a process. Once the data is fetched, it remains in your process memory as variables until either the process ends or the variable is removed from scope. That’s why, any changes you do to the entity data has to be written back to Data Service using the Update, Create or Del…

This solution provided by @nikhil.girish received 2 likes!

How to run in incognito

Hi @Trisen_Jr Welcome to community There is an option in open browser activity As properties called private Kindly check that field

This solution provided by @Yoichi received 1 likes!

How to extract data of particular row using Linq?

Hi, Perhaps you should use uppercase like Contains(“TOTAL ADD ON”) becuase of ToUpper. 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.