Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |