Iterate through a gallery or collection of emails for a flow

[Anonymous]

I have an app that I am building that needs to use a flow to e-mail those selected, however I found out that in the flow I cannot use an "Apply To Each" container as it errors out on the OnSelect Button of the form and doing research, this is a known issue for Power Apps.  Does anyone know of a workaround?  Is there like a For Each Item statement I can use in the OnSelect and then in that loop, send the parameters to the Flow.Run() statement?

Thanks

Brad

PS:  I may have found the answer here, but I will post and update if this does work: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-forall 

[Shanescows · Accepted solution]

I think this video will help.

PowerApps Collection - Send emails, sum, and format

[Anonymous]

Shane!!!!  You know I love your videos and thanks for the response.  I probably did watch this, but will watch it again.

Brad (aka GuyInKalamazoo)

[Shanescows]

Cool. Let me know if you can't get it. Happy to help. 🙂 

[Anonymous]

So then from what I understand I could just use the Office365 connector and use SendEmail and then use a Concat to iterate through the collection of emails and specify the subject and body within the function.  The second and third step in my flow then is to add a Task in the user's outlook and also add a task in a shared Planner in the HR team.

[Shanescows]

What parameters is your Flow expecting to receive? 

Code off the top of my head

ForAll(YourCollection, YourFlow.Run(UsernameParameter, TaskParameter)

In my head that works but I haven't tried it. 

[Anonymous]

Yep, that is what I am testing now and that syntax is what I need.  The flow is accepting params from Power Apps and right now it is just e-mail.  I have Expressions in the Flow to evaluate due date, etc.  My first "test" run by just using me worked as I got an email and a task in my Outlook tasks, but failed on the Planner.  I still need to work through that and my next test will include adding some co-workers to see if it will iterate through each.  I will post to let you know (and accept yours as a solution too)

[Shanescows]

Check out this video by Dan Christian for creating a Planner task with Flow

[Anonymous]

And I did just test with three people and again, the e-mail and the Task works.  I will check out that Planner vid by Dan.  Thanks for your help and keep up the great work on your videos.  I am a subscriber and watch them

[Anonymous]

In my email notification flow I had to concat the URL for our web app tenant and attach the ID of the actual task.  I guess in Planner right now there is no easy way to get a link to that task.  But anyway, it all is working now.  If I get time I might do a quick tutorial on what I just did an post it out to my website and YouTube.

Thanks again