Answered

How to find user email from user display name

(0) Share

Report

Posted on by deecheanw

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.

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

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

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Ellis Karim 11,990 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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:

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

(2) Get the Person's email address using the following expression:
outputs('Search_for_users_(V2)')?['body/value'][0]?['Mail']

(3) Set the Person's claim property:

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

Was this reply helpful? Yes No
deecheanw 27 on at

Like (0)

Report
Copy link

Link copied!

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

I'm using company email address.

Thanks,
Deechean Wang

Was this reply helpful? Yes No
deecheanw 27 on at

Like (2)

Report
Copy link

Link copied!

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
Get email through the expression: outputs('Search_for_users_(V2)')?['body/value'][0]?['Mail']
And them input email for the Claims.

Was this reply helpful? Yes No
Ellis Karim 11,990 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

For a single person, it should be straight forward:

For multi-select Person fields, see
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.

Was this reply helpful? Yes No
Ellis Karim 11,990 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
shribr 6 on at

Like (0)

Report
Copy link

Link copied!
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."}}'

Was this reply helpful? Yes No
shribr 6 on at

Like (1)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No