I have a List in my workflow. To this list, I add values extracted from multiple webpages using Add to Collection activity.
I have to store this List to an excel file over a specified range. The Write Range activity allows datatable as input. So I thought of converting the List to a Datatable but I haven’t found any expression that satisfies this use case.
Alternatively, I thought of using foreach activity on the List and assign each item to a row or column in datatable. But the datatable is empty.
Can you guys please advise on this? If you’ve some other alternative, it is welcomed.
Note: The count of items in List is undefined can be upto n values. Please refer to the attached workflow.Converttodatatableandaddtoexcel.xaml (11.4 KB)