Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 March 2022

Top 3 Topics with Most Views

How to get the Max and Min value from excel and write it to another excel made by @Krystal with 52 views.

Need a help on Group By made by @Marian_B with 51 views.

Insert header into Data table made by @Olivera_Kalinic with 47 views.

Top 3 Topics with Most Replies

Insert header into Data table made by @Olivera_Kalinic with 18 replies.

Unable to get column value in excel made by @shuklarchana001 with 14 replies.

How to get the Max and Min value from excel and write it to another excel made by @Krystal with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 62 posts!

@ashwin.ashok made 40 posts!

@Gokul001 made 39 posts!

Top 3 Most Liked Posts

This post made by @Ovidiu_Constantin received 3 likes!

Log times to contain milliseconds

Added to the backlog.

This post made by @Gokul001 received 3 likes!

How to set flow condition?

HI @fairymemay Have a look on the skeleton Flowchart.xaml (11.4 KB) [image] Regards Gokul

This post made by @postwick received 2 likes!

Whole data table as single item into an orchestrator queue

Queue Items can’t be complex datatypes. Your best option is to save the data to Excel or CSV and then reference the file path as a string in the Queue Item. It is possible to convert a datatable to JSON and put the JSON into the Queue Item as a string, but I don’t know the limitations on how much data you can do that with.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

How to set flow condition?

HI @fairymemay Have a look on the skeleton Flowchart.xaml (11.4 KB) [image] Regards Gokul

This solution provided by @postwick received 2 likes!

Whole data table as single item into an orchestrator queue

Queue Items can’t be complex datatypes. Your best option is to save the data to Excel or CSV and then reference the file path as a string in the Queue Item. It is possible to convert a datatable to JSON and put the JSON into the Queue Item as a string, but I don’t know the limitations on how much data you can do that with.

This solution provided by @ashwin.ashok received 2 likes!

How to get particular date of every month from current year?

Hi @NervousTuber , Is this what you were looking for? [image] [image] Assign → int_day = 16 int_year = 2022 Enumerable.Range(1,12).Select(Function(s) New DateTime(int_year,s,int_day).ToString("dd/MM/yyyy")).ToArray() Kind Regards, Ashwin A.K

---

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.