Hello guys, how are you?
Today I am facing a problem. I want to create a power automate flow which sends an email in power bi, everything was going good until I had to put the "TO" email, I see I have to put something dynamic and I have a measure that calculates that perfectly. Now, I have this:
I want to bring that measure named "DevManagerEmail" into my power automate flow and put it in the "TO" option. From Power BI I created a flow including the measures as 'Power Automate data'.
The moment I introduce any of the measures into the email body, Power Automate inserts a 'Apply to each' step . When I run the flow I get: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression. The result must be a valid array.
The measures are not a list or array, they only have a single possible output.
Is there a step I am missing or a work around anyone is aware of?
Thanks