You’re offline. This is a read only version of the page.
Announcements
Hello, I've created a MS Form to collect data from employees who are interested in transferring to a different location across the country. The form has 1 question that asks what state, the next question branches to a multiple choice question for the employee to select what cities they are interested in. Ultimately, the form will have 50 different Multiple Choice questions.
Once the form is submitted, I want to use Power Automate to collect the data, save in a SharePoint list, then send an email(s) to the managers of the cities for awareness. I have a seperate table for email lookups.
How can I get the data clean so it can filter the email list based on the selections entered? For example, if a user enters they are interested in transferring to Miami, Orlando, and Tampa, I would like the email to be sent to the three different managers.
Share
Report
All responses (
Answers (
503
