I wanted to create a site workflow that is executed once per day that checks to see if any items need to be reviewed based on a date, then emails the owner of the item for approval.
Because the list of items could be long, I didn't want to send out an approval email for each item. So I used a site workflow to run once per day.
It was quite tricky get the workflow to send to each owner because it was a 'person' type column, but I managed it.
My problem is that because of the above requirements, I'm left with a workflow with the flexi task inside a 'for each' loop. This means that the sending of the second email is dependant on the first person replying.
Is there any way to send all the email out at the same time?
List to act on:
Here is my workflow:
I run a query list and filter on 'Review date' < today and Lifecycle is not Retired or Superseded. I store the ID and Owner in itemIDCollection and itemOwnerCollection.
I count itemIDCollection, store in numCount and run the workflow if numCount > 0.
I then remove the duplicates in itemIDCollection and store in dedupeOwnerCol. I then run a for each:
And in the for each I get and store the owner ID and email.
I query the same list again and filter on the owner (as well as same filter conditions in first query) and save in idsCol.
I update the statuses then assign a flexi task to assignee 'dedupeOwnerEmailTxt'.
I then do a few updates based on the outcome.
The whole thing looks like this:
My issue is that I can only get the second flexi task to send after the first has been approved.
When approved, second email is sent:
How can I send all flexi tasks at the same time?