send Email Notification to list of people in Power BI using Power Automate

(0) Share

Report

Posted on by DE-22070720-0

Hello Everyone,
a question before i raise my issues .

1.is it possible to make mail triggering on table of data with a column has a flag which specifies YES or NO from PBI through power automate ?
infact it worked on Cards, KPI & Gauge with Manual run in PBI desktop.

comming to the issues which i am facing are...

I have a table in Power BI named Employee Contracts which contains:

Employee Name
Email
Contract End Date
Flag (Yes/No) — indicating if a contract is ending soon in next 15days.

I want to schedule a refresh on Power BI Service daily. After refresh, if the Flag = "Yes", I want Power Automate to trigger and send an email to that employee saying their contract is ending soon.

I’ve attempted using “Run a query against dataset” and looping over results to send an email but facing errors:

Apply_to_each not defined.
Email action fails due to broken loop references.

Can someone guide me or point me to the right solution or example for employee data use case (not sales data)?

Thanks in advance!

Categories:

Using flows

yedu_0-1753115406...

yedu_2-1753115037...

yedu_1-1753115462...

I have the same question (0)

All responses (3)

Answers (0)

Power Platform 1919 1,894 on at

Like (0)

Report

Hi @DE-22070720-0, can you please show the power automate expression used in checkflag condition and it is always better to use parseJson action to capture the fields in the step outputs.

Was this reply helpful? Yes No
Suggested answer

Tomac 3,951 Moderator on at

Like (0)

Report

Your Condition is comparing an invalid set of items. One of the items in your CheckFlag condition is referencing an Apply To Each loop that was removed from your flow.

You'll need to either add the loop back into your flow or remove the references to items generated by the loop.

Was this reply helpful? Yes No
Suggested answer

Tomac 3,951 Moderator on at

Like (0)

Report

To answer your question at the top: You can't trigger a flow on specific output from a PowerBI report. Your screenshot has the correct trigger though, Recurrence. Just set it to run after your PowerBI report is refreshed (schedule your PowerBI report's refresh, see how long it takes, and then set the Recurrence trigger to that time + the amount of time the report takes to run plus 10 minutes just in case)

Like in your example you'll then query the dataset, but you're missing the Apply To Each loop that runs against the First Table Rows output from the query. Then inside of the loop you can check the specific flag value in your Condition (CheckFlag) statement and send the email if true.

So your flow is 90% correct, it looks like you previously had the Apply to Each loop but removed it.

Was this reply helpful? Yes No