Output of filter array Listed in a Single Email

[Prajnya]

Hi Experts,

Please check the flow below, I need to send an email to Task Assignee that The task of below projects are updated in last 24 hrs. In which I need to list out all the Project ID. The below flow I have written is running successfully, but the Task Assignee is getting multiple no of emails. 

My requirement here is in a single email, the assignee should receive that tasks of the following Projects are updated. 

Please help me in this. 

[rrovira]

Hello, @Prajnya!

You could create a variable that store all the information and also have a variable that works as a loop breaker, once it's out of a certain loop you could send the email with the variable, that way it will only send an email per array and not a email per item. 

Though, I haven't tested this, but let me know if it gives you an idea! 

In the meantime I'll be working to replicate this and see if it works! 

Cheers,

Rodrigo

[eliotcole · Accepted solution]

Hi, @Prajnya, does the list have the emails of the various people that you need to email about it?

If so, then I think you can simplify your loop down to just one stage.

Run a Select action on the data, and map a key called email to the email column. (I added one for the name, so I could address them personally)

Then make an Apply to each action that runs on on a union() of that select, twice. So that's:

union(body('Select'), body('Select'))

... that just sifts out all of the same entries.

Then for the first action in the Apply to each make a Filter action on the original input where one of the sides is the email field from that and other is:

items('Apply_to_each')?['email'] .

Obviously it only works if you have an email field in the list that has the person responsible for the item.

If this isn't a solution, hopefully it just puts you on the way. 🙂