Forum Engagement Daily Reports

[system]

Daily Forum Report | 17 September 2022

Top 3 Topics with Most Views

Chrome is update and now getting Error made by @Ram_Gurav1 with 41 views.

Queue Null value made by @Ketan_Wajekar with 33 views.

The AI Fabric Section not avaliable in the Orchestrator made by @Rusira_Liyanage with 30 views.

Top 3 Topics with Most Replies

Not getting grade for Client Security Hash assignment on academy made by @Sandhya_Gajare with 26 replies.

Wait for Button to be Clickable made by @Beere_Plays with 13 replies.

How to convert IEnumerable to Datatable? made by @Muralikrishna_Surve with 8 replies.

Top 3 Users Who Posted The Most

@Sanjit_Pal made 26 posts!

@raja.arslankhan made 20 posts!

@Sandhya_Gajare made 13 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Dutta received 1 likes!

In the 'Lookup Column category' the value for argument 'Column Name' is not set or is invalid."

Hi @Fresher , Are you passing the correct column name for which you want to look up the data. Please check your column name spelling and all because this error occurs due to column mismatch. Thanks & Regards, Shubham Dutta

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

In the 'Lookup Column category' the value for argument 'Column Name' is not set or is invalid."

Hi @Fresher Could you try adding this snippet of code right before the Lookup Column Activity to check if the column is present in the Data Table during runtime? dt1.Columns.Cast(Of DataColumn).Any(Function(a) a.ColumnName.Equals("Material Code")) [image] If it returns false, then that means the Data Table isn’t being parsed properly somewhere. Also, could you please let us know what it is that you are trying to achieve here? We will try to help you out if you could provide some sample da…

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

How to convert IEnumerable to Datatable?

Hi @Muralikrishna_Surve , Could you try declaring a Variable of type DataTable and assign that to the Read Range Activity? Usually when you create a variable using Ctrl+K in the Read Range Output it generates a Datatable. As for converting an IEnumerable to DataTable, if its an IEnumerable of DataRows, then you have to append a .CopyToDataTable() method to it. Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

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

In the 'Lookup Column category' the value for argument 'Column Name' is not set or is invalid."

Hi @Fresher Could you try adding this snippet of code right before the Lookup Column Activity to check if the column is present in the Data Table during runtime? dt1.Columns.Cast(Of DataColumn).Any(Function(a) a.ColumnName.Equals("Material Code")) [image] If it returns false, then that means the Data Table isn’t being parsed properly somewhere. Also, could you please let us know what it is that you are trying to achieve here? We will try to help you out if you could provide some sample da…

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

How to convert IEnumerable to Datatable?

Hi @Muralikrishna_Surve , That can be easily taken care of. If needed, we can even add the actual headers, but if the headers are not important then you can try this. First we read the Row, then initialize the DataTable before we use a For Each Activity to keep adding DataColumns to fit the schema: [image] Then we add the row to our newly created DataTable. [image] ReadRowConvertToDT.xaml (6.7 KB) 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.