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.
User | Count |
---|---|
92 | |
46 | |
21 | |
19 | |
17 |
User | Count |
---|---|
144 | |
51 | |
42 | |
40 | |
31 |