Forum Engagement Daily Reports

[system]

Daily Forum Report | 27 March 2022

Top 3 Topics with Most Views

Queue status in orchestrator made by @T_Y_Raju with 39 views.

How to Configure Get IMAP Mail Message Activity in Ui path made by @varun_shinde1 with 37 views.

Create multiple sheets in excel file based on records made by @avinashy with 36 views.

Top 3 Topics with Most Replies

For each row in Table and If condition (build data table OK / Add data row OK) made by @Felipe_Sternberg with 19 replies.

Can Someone help me with filtering excel column which has a date made by @shilpa_p with 11 replies.

Error in Inner Join Data Tables using custom LINQ made by @kit2815 with 8 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 15 posts!

@lakshman made 6 posts!

@Felipe_Sternberg made 5 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

Create multiple sheets in excel file based on records

Hi @avinashy , That can be achieved by converting the DataTable into a List of DataTables each containing 10 records. But how you want to go about naming each sheet is still unclear, so I’ve given generic names followed by indexes (Sheet2, Sheet3…Sheetn) The logic for that is detailed below → [image] Enumerable.Range(0,CInt(Math.Ceiling(dt_sampleData.Rows.Count()/10))).Select(Function(s) dt_sampleData.AsEnumerable.Skip(s*10).Take(10).CopyToDataTable()).ToList() Could you give this a try a…

This post made by @ashwin.ashok received 1 likes!

How to Configure Get IMAP Mail Message Activity in Ui path

Hi @varun_shinde1 , You might have to enable few settings in your account for this to happen. Maybe this link could be of help? Kind Regards, Ashwin A.K

This post made by @NIVED_NAMBIAR received 1 likes!

Edit code LINQ?

@fairymemay For updating the different columns, you had to use the code like this as below DT_TextFile.AsEnumerable().ToList().ForEach(Sub(row) row("FPP")= CDbl(row("FPP").ToString)/Cdbl(row("Case").ToString)) DT_TextFile.AsEnumerable().ToList().ForEach(Sub(row) row("APSUM")= CDbl(row("APSUM").ToString)/Cdbl(row("Case").ToString)) Try this approach Thanks & Regards, Nived N

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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.