Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 November 2022

Top 3 Topics with Most Views

Difference result between run through orchestrator and studio made by @Kelvin1 with 45 views.

How to test the workflow on a new virtual desktop? made by @g_ii with 45 views.

Click activity fail when run from orchestrator made by @g_ii with 41 views.

Top 3 Topics with Most Replies

Click activity fail when run from orchestrator made by @g_ii with 23 replies.

Facing issues in web application made by @varunk with 16 replies.

How to match the variable value in excel sheet made by @sruthesanju with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 61 posts!

@Anil_G made 54 posts!

@sangeethaneelavannan1 made 22 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to Compare two data tables with specific Column data

Hi, Can you try the following sample? [image] DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"}) Sample20221123-2aL.zip (10.6 KB) Regards,

This post made by @Jayavignesh_G received 2 likes!

How to add data row in different data table of different column using linq

@adarsh_kotagiri Datatable-> DT_1 & DT_Final and Create “Result” argument as “in/out” direction. In Total 3 Datatable will be used, DT_1 , DT_Final and Result Take Involve Code Activity, Pass the DT_1 & DT_Final argument as “in” direction. then open the Code Editor, Var query = from DT_1 in DT_1.AsEnumerable() Join DT_Final in DT_Final.AsEnumerable() on DT_1.Field(“Document Number”) equals DT_Final.Field(“Cheque.no”) select new { Date = DT_1.Field<string>("Date") …

This post made by @Jayavignesh_G received 2 likes!

Extract diffrent tables with same format per emails

@iremguner - At First Read the Outlook Mail, For Each Outlook (Apply the some filter Condition if needed) → Use HTML Content create 2.Now you may got the code of Total Body Content then Keep “Date” as Start Label and “RMK” as End Label (Hint: Use the Index Logic to find position of those label) 3.Now Write those Range value from start Label to End Label into Excel. Happy Learning !!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to Compare two data tables with specific Column data

Hi, Can you try the following sample? [image] DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"}) Sample20221123-2aL.zip (10.6 KB) Regards,

This solution provided by @Hendriyanto received 1 likes!

How to install custom activities

hello @son.dc , What is your project Version? (Windows, Legacy, or CrossPlatform), if your project compatible version is Windows, not all Costum activity is supported Cheer,

This solution provided by @Anil_G received 1 likes!

Arrived email outlook trigger

Hi @nora_ziani yes you need to configure required arguments in process and then publish it and then create integration service in orchestrator. Please check the documentation in previous post on how to create process and required arguments to get data from trigger 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.