Showing results for 
Search instead for 
Did you mean: 
New Member

get User UPN from form field

Hi there - I have a form generated by my organisation that is designed to be completed by other personnel within the umbrella organisation who don't necessarily have access to the web 365 environment (hence this form is open to anyone with the link, and not refined to only those inside the org). 


In the form I have a field (called EmployeeID e.g. L1234567 (alpha character followed by 7 numbers)) where responders record their ID. This ID matches the Microsoft UPN, is there a way of using this field to get user details as part of an automated flow that appends form data to a SP list? I've had a try but it doesn't seem to pick up the link between the ID and the profile (which I can still search and see). 


Any help is appreciated 



Resolver I
Resolver I



Might be helpful to see what you've got so far with your Flow. However, there is an O365 card called 'Search for users V2' where you can use a number of things, including the UPN to search for the user in the tenancy. After this card, you have access to the user's profile information. Are you then looking to put specific parts of the profile into an SP list?

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,004)