Extracting a measure from Power BI into a String in Email

(0) Share

Report

Posted on by iglesias6

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

Categories:

Business Process Flows