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:
Flow:
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.
Any help would be much appreciated!
Turns out it was working the entire time!
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?
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!
WarrenBelz
146,537
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,908
Most Valuable Professional