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 / How to find user email...
Power Automate
Unanswered

How to find user email from user display name

(0) ShareShare
ReportReport
Posted on by 27

I have an excel spreadsheet that contains user display names. I'm trying to upload the spreadsheet to a sharepoint list.  

 

In the excel, the user name looks as below.  How can I load them to the sharepoint. 

 

deecheanw_0-1636815419887.png

 

Below is my code. but it doesn't work. 

 

deecheanw_1-1636815568719.png

 

Anyone can tell me how to do it.  Many thanks!

Categories:
I have the same question (0)
  • Verified answer
    Ellis Karim Profile Picture
    11,681 Super User 2025 Season 2 on at

    Try using the following format to set the Person field:

     

    {
    	"Claims": "i:0#.f|membership|AdamV@MS365.com"
    }

     

     

    (1) Search for the Person using the Display name from your Excel file:

    2021-11-13_17-36-11.png

     

    However,  search for the person using first-name and last-name format, returning only 1 result:

    2021-11-13_18-05-39.png

     

    (2) Get the Person's email address using the following expression:

    outputs('Search_for_users_(V2)')?['body/value'][0]?['Mail']

    2021-11-13_17-55-36.png

     

    (3) Set the Person's claim property:

    2021-11-13_18-00-48.png

     


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

  • deecheanw Profile Picture
    27 on at

    It doesn't work for me.  I successfully get the email address. But the claims can't be recognized. 

    deecheanw_0-1636845335491.png

     

    I'm using company email address. 

     

    Thanks,

    Deechean Wang

     

  • deecheanw Profile Picture
    27 on at

    It turns out in the Claims, I just need to put the email address. No need to be json format. And also no need to add "i:0#.f|membership|" 

     My solution is 

    deecheanw_1-1636886174725.png

     Get email through the expression:  outputs('Search_for_users_(V2)')?['body/value'][0]?['Mail']

    And them input email for the Claims.

    deecheanw_0-1636886086168.png

     

     

     

  • Ellis Karim Profile Picture
    11,681 Super User 2025 Season 2 on at

    For a single person, it should be straight forward:

    2021-11-14_10-24-39.png

     

    For multi-select Person fields, see

    2021-11-14_10-28-57.png

    Mentioned here:

    https://powerusers.microsoft.com/t5/Building-Flows/RE-Bulk-Upload-into-SP-list-Ignore-empty-cells-and-upload-only/m-p/1325423#M150253

     

    To Clear a Person is a bit more tricky
    https://powerusers.microsoft.com/t5/General-Power-Automate/how-to-clear-a-person/m-p/1322461#M80045

     


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

     

  • Ellis Karim Profile Picture
    11,681 Super User 2025 Season 2 on at

    Yes, I was thinking Power Apps for some reason 🥴. To patch a person requires only the email address:

    ekarim2020_0-1636886441905.png

    Ellis

  • shribr Profile Picture
    6 on at

    I get an error when trying to use any of the V2 Office User connectors.

     

    Request to Azure Resource Manager failed with error: '{"error":{"code":"InvokerConnectionOverrideFailed","message":"Could not find any valid connection for connection reference name 'shared_sharepointonline_1' in APIM tokens header."}}'

     

  • shribr Profile Picture
    6 on at

    I just solved my own problem.

     

    Try testing flow Manually and NOT Automatically (i.e. don't test flow with a recently used trigger under the Automatically option).

     

    For reference: https://www.encodian.com/blog/fix-the-request-to-azure-resource-manager-failed-with-error-in-power-automate/

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 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard