web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extracting a measure f...
Power Automate
Unanswered

Extracting a measure from Power BI into a String in Email

(0) ShareShare
ReportReport
Posted on by 50
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:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard