Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 November 2025

Top 3 Topics with Most Views

How to extract only email address from string made by @anand_kumar4 with 15 views.

リモートデスクトップでチェックボックスをクリックする方法 made by @gorby with 15 views.

How to use object repository from Project 1 to Project 2 made by @Vanitha_VS with 15 views.

Top 3 Topics with Most Replies

Invoke Workflow fails to get correct UiElement made by @wehnicde with 6 replies.

How to sum group by values in excel data made by @anand_kumar4 with 4 replies.

How to extract only email address from string made by @anand_kumar4 with 4 replies.

Top 3 Users Who Posted The Most

@MohammedShabbir made 21 posts!

@Anil_G made 16 posts!

@prashant1603765 made 7 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 2 likes!

Priorities and triggers, how to give different queues different priorities?

The job being triggered has no awareness of the items in the queue and their inherent priority. If you want one queue to be treated as a higher priority then in the trigger you can raise the job priority, this should help make sure that job runs first, but it will then complete all the items in the queue, irrespective of priority, before finishing and letting the next lower priority job run and process its queue items. Queue item priority only affects the next item to be processed from the que…

This post made by @alejandro.tapia-hernandez received 2 likes!

Error when replacing value in excel cell

@sobin_paul It is because you are using “use excel file” activity and “Read Column” activity, they open Excel in two different ways. I recommend you to better use “find/replace Value” activity, just as @Anil_G mentioned, is faster because the process doesn’t loop and it’s more simple: [image] And be sure to uncheck the “keep excel file open” property inside the “Use Excel File” activity: [image] This option will autmatically close your excel file

This post made by @ppr received 2 likes!

How to sum group by values in excel data

You can prepare a Datatable with the grouped and sum up values, then you can filter or postprocess it and writing back the result to excel Assing Activity: dtGroupSums | DataType: DataTable = YourDataTableVar.Clone() Assign Activity: dtGroupSums= (From d in YourDataTableVar.AsEnumerable Group d by k=d("Name").toString.Trim.ToUpper into grp=Group Let gs = grp.Sum(Function (x) CInt(x("QTY").toString.Trim)) Let ra = new Object(){k,sm} Select r = dtGroupSums.Rows.Add(ra)).CopyToDataTable Also…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How to extract only email address from string

@anand_kumar4 please try this regex ([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+) Also you have find matches activity where you can use it or use directly with regexexpressions [image] 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.