Help with using a Flow and sending Bulk emails

[TheNewGuyAtWork]

Hello! I'm super new to power apps and even newer to flows.

The extent on what I've done so far is create buttons that patch Sharepoint records for current users. What I'm trying to do now is send out some bulk emails to a number of users dynamically. Let's say I click on the second gallery item and move to the next screen, I'm trying to send out an email from the current user on a button press to all of the users who belong to that second section (As denoted by their Sharepoint item which has a column for session). I've tried doing this with ForAll directly in power apps but it seems a flow is needed. I'm unsure how to pass this number, which is a variable in my power apps, into the flow and filter who gets my email.

Sorry, I know this is a involved question, and I may have not worded something super well, so let me know if I can provide screenshots.

[WarrenBelz]

Thanks @TheNewGuyAtWork ,

Is this what you are trying to do?

ClearCollect(
   StudentCollection,
   Filter(
      'WkShp Registration List',
      Session_x0020_ID_x003a_Title.Id=2
   ).Email_x0020_Address
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[TheNewGuyAtWork]

YES Exactly! Thank you. I changed my code to now have the ID that changes:

ClearCollect(
StudentCollection,
Filter(
'WkShp Registration List',
Session_x0020_ID_x003a_Title.Id= varParentItem.SessionID
).Email_x0020_Address
)

The last issue I face before I think I can throw the collection in the for all, is that the email was a nested record. Meaning the email field I just filtered by has its own set of attributes. I tried doing .....).Email_x0020_Address.Email or 'Email' but I get an error. I'll send a pic of what it filtered down to, but I have to blank out the personal info.

[WarrenBelz · Accepted solution]

Thanks @TheNewGuyAtWork ,

You gotta love complex field types (I totally avoid them - you might have a quick read of this blog of mine ) - however try this

ClearCollect(
   StudentCollection,
   AddColumns(
      Filter(
         'WkShp Registration List',
         Session_x0020_ID_x003a_Title.Id=varParentItem.SessionID
      ),
      "EMailAddress",
      Email_x0020_Address.Email
   ).EmailAddress
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.