Query Assigned To users and then send email


Badge +8

Hi,

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,


2 replies

Userlevel 4
Badge +7

hi

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.

‌ should help with the operations.

Let me know if you need any more help with the workflow

Userlevel 5
Badge +13

There's a similar question here: Multiple List Items Sent to One Person  that had some great input from Giacomo Gelosi, including his blogpost on the topic  

Reply