Append to array variable

[ianboothman84]

Good Afternoon

Hope you are well. 

I am trying to create a Power automate to allow data from my BI be exported to a user via email. 

so far i can not get the apply to each to work 😞

the set up

 please can someone point me in the right direction 

Ian 

[Ameer]

Hi,

May be it's a simple question, but i tried a lot and i cannot get it.

How did you get the Json fromat from the Power BI for the value field of append to array variable?

Thank you

[v-yangliu-msft]

Hi  @ianboothman84 ,

This is the related document, you can view this content:

Export and email a report with Power Automate - Power BI | Microsoft Docs

Power BI - Export Report and Email to Current User (Power Automate) - YouTube

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.