Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 February 2023

Top 3 Topics with Most Views

Add comment to cell made by @arina with 54 views.

Older date made by @GDMM with 46 views.

Can i use wildcard(*) in assign activity made by @pravin_bindage with 44 views.

Top 3 Topics with Most Replies

「OneDriveとSharePointを使用」の利用について made by @_kurosawa_daisuke with 15 replies.

Can i use wildcard(*) in assign activity made by @pravin_bindage with 15 replies.

Regexproblem made by @Kuldeep_Pandey with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@Sudharsan_Ka made 45 posts!

@Mark_Rajkumar made 16 posts!

Top 3 Most Liked Posts

This post made by @g.ward received 3 likes!

UiPath Apps 'Stop Process' Function

Hi, I had a request from a customer to build in a simple pause/stop function for a long running bot, as sometimes they need to kick it off the software it runs on to allow them to complete a task. I was hoping this would be a quick job, a simple pause button I could build into the existing UiPath App they have to send a stop process command, but it looks like that is not an option - you can only start a process. I considered building a second bot to send the stop command via an API, but that …

This post made by @RobertRussell_Monsalud received 2 likes!

Conversion from type 'DBNull' to type 'Integer' is not valid in Excel

Hi @fernando_zuluaga and @Anil_G! Thank you so much for your help. If there is only a way to mark as a solution both of your responses, I would have done it. Best regards, Robert Monsalud

This post made by @iamNairda received 2 likes!

I need help plz ..ideas of busniess process in uipath

Maybe you find something good in the Use Case repository:

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Conversion from type 'DBNull' to type 'Integer' is not valid in Excel

@RobertRussell_Monsalud You have two options here… Use excel formula using write cell …first read the datatable which will give you the rowcount = dt.Rowcount Now use write cell with values as "= Sum(B2:B" + rowcount.ToString + ")" and cell as “B” + (RowCount+1).ToString Or Read the datatable then use assign activity as below Sum = dt.AsEnumerable.Sum(function(x) if(IsNothing(x("Games Played")) OrElse String.IsNullOrEmpty(x("GamesPlayed").ToString.Trim,0,cdbl(x("Games Played").ToString))) …

This solution provided by @supermanPunch received 1 likes!

How count present date count based on find least count date present cell value

Hi @Raja.G , Could you Check with the below Expression : DT.AsEnumerable.OrderBy(Function(x)x.ItemArray.Skip(2).Where(Function(y)y.ToString.Contains(Now.ToString("MM.dd.yy"))).Count).First.Item("Name").ToString Here, DT is your Datatable variable. Let us know if it doesn’t work and what was the error received.

This solution provided by @Anil_G received 1 likes!

How to activate Flex License? Which orchestrator to use for Flex License? As there is no orchestrator license

@nisargkadam23 I believe that should be same… But as you have a chance of messing up…Would suggest contact the support …They would confirm as well if there are any issues Because as per docs that I shared as well I don’t see any separate way to do but use the same as one thing for sure is that there isn’t any separate license for orchestrator at all… license is basically for orchestrator to understand what you purchased cheers

---

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.