I have used When a Power BI goal status changes, send e-mail to build a flow. It works and I'm happy with that but the issue I currently face is that this alert triggers based off of one goal on the scorecard. I have around 6 scorecards with a total of about 200 goals for different areas.
I would like to build the flow so that it triggers based off of any goal on the scorecard not having a status of completed.
I have done a bit of research and think the "For Each" condition should help me but I'm not sure how it all works. I've only been using PowerAutomate for about a week, I'm happy with what I've accomplished so far but could really use some help on taking this to another level.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.