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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Multiple User Emai...
Power Automate
Unanswered

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard