Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Creating alert on text card (PBI + Power Automate)

Hi everyone, 

I am currently working on integrating my PBI report with Power Automate through the use of  dashboard alerts. However, I don't see an ability to create an alert that would trigger based on a text field (basically I need the alert to trigger with each data refresh and the value for Power Automate to be a text measure) - only greater/smaller number is allowed.

Is there a posibilty to set up such alert, or, if not, to get data from Power BI to Power Automate (we do not have premium capacity) in any other way?

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous You cannot trigger on a text field, but you could create a measure like:

    Alert Measure = IF(MAX('Table'[Column]) = "<Alert text>",1,0)

     

    Then you could alert on that.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yeah, it would, but the text itself won't be included in the alert message nor be forwarded to Power Automate, right? I think it will just say something like "Alert Measure is greater than 0", what doesn't really work for me ☹

  • MSUser's avatar
    MSUser
    Frequent Visitor
    3 years ago

    Is there any possiblity today, to use text as trigger?

     

    Just as was written before, the aim is to have particular text included in the alert message so it can be forwarded to Power Automate