Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

How to get variable items of Flow on a Scheduled Email to multiple users

I've am trying to create a flow that that every 6 months automatically sends a email to a group of administrators requesting from them to review and revise there designated Flow since processes change over time in each team.


I have been able to get the basics put together but I am still a beginner at Microsoft Flow, so help with be appreciated!


These are the ideal requirements

- A email is automatically send out to all the admins every 6 months asking them to revise there designated Flows

- Included in the email is an file attachment from SharePoint, however each recipient has a different file that is assigned to them which needs to be attached.


 So If I have 5 different administrators, and have 5 different processes. The flow needs to send an email for example to with a generic body message and have attached the file that is pulled from the SharePoint folder with the variable of John Smith as the process owner.


Please view these 2 screen shots for references. 








Super User
Super User

Hi @kpiana , I would do this with a Switch case control, a type of Condition. In my example (images below) I have the SharePoint list with a column called Owner. In the flow I add the recurrence schedule, then get the SharePoint items, then add a Switch control based on the Owner. That will wrap itself in an Apply to each, then for each switch case you specify what the Owner must equal, then you can add the actions for each of the cases. So If the Owner column in the SharePoint list equals Miguel then send an email to Miguel and put whatever you need to in the email and add the attachments and any further actions. Then you do the same for each of the other owners. I think you can have up to 26 or 27 switch cases as far as I recall.

Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.


Lists with initial valuesLists with initial valuesTrigger and Get PointsTrigger and Get PointsSwitch control inside an apply to eachSwitch control inside an apply to eachGet current cumulative points and put them in a Compose controlGet current cumulative points and put them in a Compose controlAdd Compose controls for new points, add them to cumulative pointsAdd Compose controls for new points, add them to cumulative pointsUpdate the cumulative points list with the additionUpdate the cumulative points list with the additionReset current points list to 0Reset current points list to 0Add the actions for each personAdd the actions for each personThe result in the 2 listsThe result in the 2 lists


Hello, thank you for your response. So I was able to follow what you did up until where we added the switch control. This is where I got lost since I am not sure how to use this feature and what exactly it is doing. I additionally added a List, however for the files that need to be attached, do I leave those where they are? If so how does this flow pick the attachment?


Thank you in advance!





Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,651)