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

[yedu]

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.

1st I want to schedule a refresh on Power BI Service daily.
 2nd 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.
3rd i am facing issue with query Text.

4th i have emails in table column ,i want use them dynamically.

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

1. Apply_to_each not defined.

2. 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!

[v-venuppu]

Hi @yedu ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

Can you please post the question in Power Automate community to answer your question effectively as this is Fabric community.
You can use below link to Post your question:
Microsoft Power Platform Community Forum Thread

Thank you.

[lbendlin]

Your flow is only running once.  You need to use the "First Table Rows"  result of the "Run a query"  step to create the "Apply to each" loop.

[yedu]

thanks for your suggestion can you  brief with samples or with sample data please .

and i am facing this issues as well today

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each, Apply' referenced by 'inputs' in action 'Send_an_email_(V2)' are not defined in the template.'

[lbendlin]

Let's fix the DAX query first.  What are the error details behind the "BadRequest" ?