Hi Team,
I am currently trying to create a power BI report that is integrated with Microsoft Flow to send out email to multiple employees. Below you can find more information about Data Source and Current Challenges.
Data source: Project Data Service(Odata feed).
I have Table with Columns - EmployeeName, Status, Week, Email.
The report has 1 table with all the above colmns and 2 slicer, 1 for week and other for status. I need to filter Employeename for current week that has status- Inprogress.
Endgoal- To send out email to all the employees that are filtered in this report.
Challenges:
1. how can I pass the email list from power BI to Flow?
2. I tried using PowerApps , but there is no data connector similar to Odata feed to connect to entities from project Data Service
3. I can create a data alert on the count of Employees in a label and trigger the flow, however I am not sure on how can I pass the email list from the Power BI to Flow.
Any help on this is appreciated.
Thanks
Same here. There must be a way of triggering a Microsoft Flow from a Power BI report. The report should be parametrized by any available filters on the report and result in a list sent as input data to Flow. Flow can do the rest - like email lists, etc... But there is no Flow integration starting from a filtered Power BI report.