send one email with multiple alert title

[Pikachu-Power]

Hello,

I am a newbie in Power Automate and need some help 🙂

I have 5 Power BI Alerts. When they are triggered 5 emails will be send. One email for one alert.

Now I want to send one email with an information about the 5 alerts. When an alert is triggered i want to see the alert title in the email text, if the alert is not triggered i dont want to see the alert title in the email text.

I started with the following idea: 

This flow dont work. I suppose because there is some relationship between the alerts. If the first alert is not triggered the following alerts will not be checked. The other way if the first alert is triggered i get an email that says all 5 alerts occured.

So how can i create an email with 5 independant alert title information in the email text?

Thanks!

[leo85]

Hi @Pikachu-Power ,

check out run-after conditions. This is generally a very useful feature in flows.

What you can do:

1. Initialize 5 boolean variables at the beginning of your flow, before the alerts, and set them all to "false".

2. Add a "set variable" action after each alert and set them to "true".

3. Configure the "run after" condition of the "set variable" actions to only run, if the previous action failed.

Now you have got 5 variables that are set to "true" if the respective alert failed and "false" if it succeeded. Now you can edit the text of your email depending on the value of these variables.

Regards,

Leo

--------------------------------------

If my answer solved your issue, please mark it as complete.

If what I wrote helped you, please give it a thumbs up.

[Pikachu-Power]

hello leo85,

can you may post a screenshot (maybe with 2 alerts as an example)? have already problems at the first stepp. I get the message that Initialize variable is an action and not a trigger and i cant start so.

and where to put the email part. the order is not clear to me yet.

Thanks.

[leo85]

Hi @Pikachu-Power ,

what kind of actions are the actions in your screenshot "First Alert", "Second Alert", ...? I cannot find "alert" actions, only "alert" triggers.

My idea originally was:

• Initialize variable Alert 1 = false
• Initialize variable Alert 2 = false
• ....
• First Alert
• Set variable Alert 1 = true (if "First Alert" failed)
• Second Alert
• Set variable Alert 2 = true (if "Second Alert" failed)
• ....
• Set variable Alert 5 = true (if "Fifth Alert" failed)
• Send email

Regards,

Leo

[Pikachu-Power]

Hello leo85,

The alerts in my screenshot are these one:

But it is not possible to start a flow with action (=> Initialize variable) and after Set variable Alert 5 it is not possible to continue with send a email.

Best Regards.

[leo85]

Hi @Pikachu-Power,

"When a data-driven alert is triggered" is a trigger. You cannot have it five times in a row. It can only be at the start of your flow. Afterwards follow normal actions. I don't quite understand how you created that flow, because Alerts 2-5 cannot be of the type "When a data-driven alert is triggered".

In my opinion your flow needs a totally different structure. You may need multiple flows or save triggered alerts in a list to summarize them in an email. If you summarize alerts, you need to specify the time for which alerts will be saved.

Regards,

Leo

[Pikachu-Power]

Hello,

To do it separated is no problem. That works. But summarize in an email is more complicated it seems.

So your suggested way with  boolean variables wouldnt work? Can you explain the steps for summarize in detail? The building blocks in power bi are new for me.

Best Regards.

[leo85]

No, the way with boolean variables does not work, because the "Alert" actions don't work that way. They are triggers, not actions. The actions in your original screenshot cannot all be "When a data-driven alert is triggered" actions, because these are triggers and there can only ever be one trigger in a flow.

The following is one example you could try:

Create 5 flows. Each with the "When a data-driven alert is triggered" triggered and an action to write the result in a SharePoint list. Then you have a regular flow, which runs maybe once a day (depending on how often you want to send the summary). This flow reads the items in the SharePoint list and send an email with their data. Afterwards it deleted all items from the SharePoint list.

Regards,

Leo

--------------------------------------

If my answer solved your issue, please mark it as complete.

If what I wrote helped you, please give it a thumbs up.

[Pikachu-Power]

Hello leo85,

Thanks for your idea! I think it works now. I used following idea:

How to send multiple list items in ONE email using Microsoft Flow - YouTube

Then I start with Reccurence and end with Apply to each for delete the items in the list again. 

One last problem (i dont know if someone can help me):

When a data driven alert is triggered I get the same items double or triple and sometimes just once. I mean in the "Create Item" step. Same titles once, double or triple.

Someone know how to fix that? Or maybe it is possible to use "Get Items" with a kind of DISTINCT? 🙂

Best Regards.