I need to upload some new data from an SQL table into SharePoint List every midnight. My idea is to use Workflow:
- Exeute SQL and save into WF collection variable
- For Each the collection
- if my condition then
- update Sharepoint List
I would like to ask you if it is possible to do it in that way?
How can I test the value of a collection item in one iteration - something like CollectionVariable[counter].Name?
Thank you for your hints,