Forum Discussion
Power Automate send weekly emails
I am trying to simply send a weekly email with the value of a metric in my power BI report. To do this, I have created a scorecard metric and connected it to a tile in the report. Then, in Pow...
When I chose "Check-in Note Text", It gives me this...
There is an option for Check in Value.
However, when I run the flow with this set-up, I get this error:
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Get_a_goal_check-in')?['body/value']' is of type 'Float'. The result must be a valid array.
I think you are iterating at the wrong level, and with Power Automate you will need to tinker with it. I would put the "Check in" in the Apply to each, and the Check in Value in the content of the email itself.
If the "Check in" doesn't work, try the Check in Status. A bit of trial and error here.
