Totally lost with Power BI triggered flow

[daffodillfern]

Hi all

Apologies for coming here as a complete novice, but I've been trying to figure this out for two days and I'm totally lost. 

I have a Power BI report that lists out items requiring attention by users in my organisation. I want to send an email to users to let them know when their name appears on this report.

I've set up a PBI alert to run when attention is required by any user in my organisation, and this is working correctly. I'm using this to start my flow with "When a data driven alert is triggered". Next, I'm using "Run a query against a dataset" to get an output of the email addresses for the users who need to be notified. Again, this is working correctly - in tests I get an output of:

[

  {

    "User[Email]": "email1@email.com"

  },

  {

    "User[Email]": "email2@email.com"

  }

]

I'm now stuck with what to do next. I tried passing the output from this step into a Mail step, however it's passing "User[Email]":"email1@email.com" instead of just "email1@email.com" as the recipient, and this is obviously not a valid email address. I've also tried using a Parse JSON step to pull out just the email address, but it's not happy because I'm passing it an object instead of an array. I know that I need to use an Apply to each step to encompass the Mail step, but I have no idea how to give it the email addresses in the right format.

Any help would be greatly appreciated, this is my first foray into Power Automate.

Many thanks

df

[lbendlin]

Nearly there. You can use a Select inside the Apply to Each  in order to map your array values to something you can then use in the email step.