Power Bi Automate - Dynamic list

[VikramShah]

Hi,

Currently while using automate I am sending direct emails to users to correct the segment information. But the problem that I am facing is that if there are more than 1 order associated with any segment for an user then there are multiple mails which are sent to user. I want to consolidate the order nos in one dynamic list and send only 1 email and not multiple emails. In the below example for User B there are 3 emails which are sent for Segment - Not defined as there are 3 different orders. Can I consolidate these 3 orders in only 1 email.

[v-xulin-mstf]

Hi @VikramShah,

Your send email notification action is in a loop that runs once for each segment - therefore an email is sent for each segment.

You need to create an array that contains the segment and then send a single email and add the array.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[goncalogeraldes]

I think this is a question for the Power Automate Community and not Power BI community.

https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

Nevertheless, basically you have to fetch the whole list, then you have to create a HTML table and insert the needed data. After this, you have to get table output into a "Compose" and send these output as an email. If you want to have a filter it must be before you create an HTML table!

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes