I need to upload some new data from an SQL table into SharePoint List every midnight. My idea is to use Workflow:
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,