web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Multiple User Emai...
Power Automate
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!

 

 

Categories:
I have the same question (0)
  • bibhupanigrahi Profile Picture
    240 on at

    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!

  • Mailmansgotmail Profile Picture
    15 on at

    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?

  • Verified answer
    Mailmansgotmail Profile Picture
    15 on at

    Turns out it was working the entire time!

     

    Mailmansgotmail_0-1605051317473.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard