Power Automate send weekly emails

[spencerhoyle10]

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 Power Automate I need to figure out how to send an email with that current value every week. 

In the email action... there is no dynamic content for check-in value. 

Anyone have a solution?

[edhans]

On the right hand side of that Dynamic Content there should be a "see more" or similarly named link. Click that to see all available content.

[spencerhoyle10]

[spencerhoyle10]

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.

[edhans]

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.