Creating alert on text card (PBI + Power Automate)

[Anonymous]

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?

[MSUser]

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

[Greg_Deckler]

@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]

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 ☹