Schedule Run of Power Automate Flows created with Power bi

(0) Share

Report

Posted on by topazz11

I have a power automate visual inside my power bi report. That flow needs to be triggered on demand (on click) in the report but I am looking for a way to automatically trigger that flow on a schedule (daily).

the flow is to send email to the person if % is more than 100%

Is there a way to do it?

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Schedule Run of Power Automate Flows created with Power bi

Hi @topazz11 :

If the data source is a BI dataset, then I am afraid that this requirement cannot be achieved(As far as I mentioned in this post). If you consider using another data source like SharePoint or Excel (saved in OneDrive),you could try this solution:

1\Create a Schedule flow that triggers daily

2\Get all rows form the data source

3\Use the filter array action to filter out records with a percentage greater than 100%

4\Use the apply to each function to traverse the filter results, and send an email to each eligible user in the loop body

Best Regards,

Bof