I have a Microsoft Form to collect students' interests in different clubs. One of the questions is a multiple-choice question where students can select more than one club. I want to automate the process of sending an email to each of the selected clubs to indicate the students' interest in joining.
I have a SharePoint list that contains email addresses for each club.
---
Current Approach:
Currently, I am using conditions to match the selections and send emails to the respective clubs in parallel.
---
Desired Approach:
Instead of using multiple conditions, I want to store the output of the multi-selection question and then run a loop to retrieve the email addresses from the SharePoint list. This way, I can populate and send the emails dynamically.
This approach allows for easy updates. When new clubs are added, I can simply update the form and the SharePoint list without needing to add more parallel conditions.
---
Questions:
1. How can I store the output of the multi-selection question?
2. How can I run a loop to retrieve email addresses from the SharePoint list and send the emails accordingly?
---
Objective:
To create a dynamic flow that adapts to changes in the form and the SharePoint list, making the process of sending emails to the selected clubs more efficient.
My Compose below is just a labelled action telling you to do whatever you need to do to take the Choice value
and query SharePoint or Dataverse or whatever you have the email stored in, so you can get it back so you
can then Send you Email
With my Apply to each the choice value = currentItem()
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
