I have a list where multiple list items are assigned to users and the idea is to send only single email every day with all the list of items (links to list items) that each are assigned to until the status field = completed.
How can I achieve this using Scheduled workflow?
Thank you in advance,
Solved! Go to Solution.
How i would approach this would be to query the list and get all the assigned users. Then i would perform a remove duplicates collection operation to get a deduplicated list.
Then i would do a for each on each member of the collection, query the list for all items assigned to the relevant user and the build the email body from the return collection of items, using foreach again to iterate through the items and get the desired output.
Let me know if you need any more help with the workflow