Share
Report
2Hi,
I have a Power BI Scorecard with a goal and multiple subgoals underneath it. Each goal and subgoal has different owners. I would like to send a weekly email to each goal owner with details of just the goals they own.
To attempt this, I started with the flow template "Periodically e-mail a Power BI scorecard status." This uses the "Get multiple goals (Preview)" action to build up a Html table of all goals within the scorecard and send as an email. I thought I might be able to modify it to selectively email specific goals to the corresponding goal owners instead, but I have been unable to figure out how it could be done. I also don't want to have to create a flow for each goal and owner combination as this would be unmanageable and inflexible, so want to send multiple customised emails using a single flow only.
I think to do this it needs "Apply to each" and arrays to build each customised email, but have been unable to figure out how and where these actions might fit into this template, and whether it's even the most suitable template to use.
Thanks for any help!
All responses (
Answers (
