Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Get Multiple User Emails from Microsoft Forms submission

(0) ShareShare
ReportReport
Posted on by 15

Hello!

 

I am trying to grab user emails from a Microsoft Form question, then sending an approval email to EACH selected user.

 

Whoever is filling out the form can select MULTIPLE users "First Name, Last Name" OR choose "None".

 

How do I grab multiple users' email address by just their first and last name?

 

MSFT Form's Question:

Mailmansgotmail_0-1604699640651.png

 

Flow:

Mailmansgotmail_1-1604699967208.png

 

 

Update:

Another test I was trying was to use "Search for users" to pull the UPN of the array of users. However it stops after the first user.

Mailmansgotmail_0-1604711129984.png

 

Any help would be much appreciated!

 

 

  • Verified answer
    Mailmansgotmail Profile Picture
    15 on at
    Re: Get Multiple User Emails from Microsoft Forms submission

    Turns out it was working the entire time!

     

    Mailmansgotmail_0-1605051317473.png

     

  • Mailmansgotmail Profile Picture
    15 on at
    Re: Get Multiple User Emails from Microsoft Forms submission

    Thanks for the insight! Much appreciated!

     

    However, is there not a way to have the "Search for Users" search through an array of User Names and spit back out their UPN's for each user name?

  • bibhupanigrahi Profile Picture
    240 on at
    Re: Get Multiple User Emails from Microsoft Forms submission

    hi @Mailmansgotmail , in my experience, 'Search for users (V2)' is limited in functionality and doesn't often get the correct user when using display name or a part of it as the search string. I use workarounds for such scenarios. I use either a mapping list with user display names and emails in a SharePoint list so that I can get the email from the display name. This works well where the number of selectable users is small, which seems to be your case. In other cases where anyone from our GAL can be selected, I use a SharePoint/Power Apps form instead of using MS Forms.

     

    Hope this helps!

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,537 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,908 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow