I have a list on which there is a field called Manager1Email and field called NextReminderDate.
If Today=NextReminderDate, a reminder email should be sent to Manager1Email.
At the end the "NextReminderDate" field should be set to NextReminderDate+14days (for the next reminder).
I have created a site workflow and the output is defined as "separate output per column" (and not collection, so that I can use the separate fields, such as Manager1Email).
But then I'm not sure how I can go over each item to send the email. ("For Each" needs a collection variable which I don't use.)
Hope you can help me with defining the workflow.
I've attached a screenshot of the workflow.
If you're using the query list and the 'Separate Output per Column' this by default will output to collection variables for each of the columns specified. You should be able to use the for each with these columns. Make sure to specify a variable for the index in the For Each, so you can retrieve the other columns using a Get Item from Collection within the For Each loop.