Not applicable

Recurring upload data from sql table


I need to upload some new data from an SQL table into SharePoint List every midnight. My idea is to use Workflow:

  1. Exeute SQL and save into WF collection variable
  2. For Each the collection
    1. if my condition then
    2. 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,


Tags (1)
0 Kudos
1 Reply
Not applicable

Re: Recurring upload data from sql table

0 Kudos