Showing results for 
Search instead for 
Did you mean: 
New Member

Store the value of measure (string) into Email Values

Hi Everyone, 
As the subject suggests, I currently have a flow below that picks up the data of a table, stores it into a html table and sends the table via email. 



However, I can't seem to make the email address be dynamic based on a measure stored in Power BI. It would always suggest the control "Apply to each" and what happens is it keeps on sending an email for each row in the whole table. Does anyone have an idea on how to just get the value of the measure and store it as an email address for the Send an Email task?

Thank you.


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,845)