Forum Engagement Daily Reports

[system]

Daily Forum Report | 07 April 2022

Top 3 Topics with Most Views

Get value from the string made by @Majunu09 with 47 views.

Get Text: The UiElement is no longer valid made by @Shinjid with 39 views.

DT expression not working made by @Marzimo0404 with 37 views.

Top 3 Topics with Most Replies

How to extract only the duplicate rows based on a certain value made by @shilpa_p with 26 replies.

Get Text: The UiElement is no longer valid made by @Shinjid with 25 replies.

Get value from the string made by @Majunu09 with 24 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 54 posts!

@shreyash_shirbhate made 34 posts!

@supermanPunch made 31 posts!

Top 3 Most Liked Posts

This post made by @Remus_Rusanu received 3 likes!

Introducing Automation Cloud Robot - Serverless! Limitless robot power with zero infrastructure

For the moment the triggering capabilities are 1 event → 1 job. We are considering triggers that queue items instead of starting jobs in the future.

This post made by @lawes received 3 likes!

Video Processing Custom Activity

I’m excited to announce a new custom activity to extract image frames and audio from video files. The activity is intuitive and easy to use. I will provide the link to the activity shortly. It makes use of the FFMPEG library. Please download it from here: https://www.gyan.dev/ffmpeg/builds/ffmpeg-release-essentials.zip You can unzip it and place it anywhere on your machine. You’ll refer to it’s location in the activity.

This post made by @GlennRoberts received 2 likes!

Getting error trying to start a process via app

I am getting the following error when trying to start the process from an app - unable to create orchestrator webhook with message: You are not authorized! and error: {“statusCode”:403} within the app the user permissions have been granted. Within the tenant and folder the user has automation user and the allow to be automation user permission. The robot can be started manually by the user within the folder. Any help would be much appreciated. Thanks Glenn

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Deduplication of 2d array

give a try at (From x in YourArrVa Group x by k1=x(0), k2=x(1),k3=x(2) into grp=Group Select r=grp.First()).toArray

This solution provided by @ptrobot received 1 likes!

DT expression not working

Have you checked if you have cell with null value(s) where column X is empty? E.g. the first three rows in the table below have null values: With the expression "[Dosage]+[Drug]+[PatientID]" in Sum column you get: [image] If you modify the expression to check for null and replace it with an empty string, you will get: Expression: "ISNULL([Dosage],'')+ISNULL([Drug],'')+ISNULL([PatientID],'')" [image] So your null safe expression should be: "ISNULL([Commodity],'')+ISNULL([Trade_Type],'')+I…

This solution provided by @Alberto_Palma received 1 likes!

"The given path's format is not supported", but it work if I write the same in inmediate

I solved it using a Array of string variable to store the “Directory.GetFiles(FolderPath)” result, and it works without issues, I do not know why it happens, but it solves the code. Thank you for your time and effort Nithin!

---

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.