AnsweredAssumed Answered

Recurring upload data from sql table

Question asked by xvanic04 on Oct 18, 2014
Latest reply on Oct 18, 2014 by xvanic04


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,