Forum Discussion

spencerhoyle10's avatar
spencerhoyle10
Frequent Visitor
3 years ago

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 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?

Need Help
Show and Tell

4 Replies

  • edhans's avatar
    edhans
    Community Champion
    3 years ago

    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's avatar
        spencerhoyle10
        Frequent Visitor
        3 years ago

        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.