Unanswered

Power Automate retrieve email address given internal SharePoint user profile ID

(1) Share

Report

Posted on by will266

Using Power Automate with a SharePoint 2019 on-premise list. List has 300+ columns, and so I am using "Send an http request" action to get item details.

Am able to get to the point where I am sending a notification using my retrieved information, but the information returned for Person/Group column comes back as the internal ID of the user in the local SharePoint site profile store - the ID number that is generated the first time a user's value is used on a list on the site. In my JSON response I am able to see the value as an integer and a string, but I need to get from the value to an email address.

JSON response body snippet:

"FacilityRatingEngineerId": 29,

"FacilityRatingEngineerStringId": "29",

How do I cross-reference this value to the email address in the site's user profile store? I am thinking it is some sort of Get Items action, as the Get User Profile action is more for O365 sites...

Thanks!

Categories:

General topics

All responses (4)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @will266

does the person column type contains the email id of person as well ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
will266 18 on at

Like
a
(1)

Report
Copy link

Link copied!

Unfortunately those are the only two values related to the column returned in the JSON.
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @will266

will get items action does not work for you ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
will266 18 on at

Like
a
(2)

Report
Copy link

Link copied!
Unfortunately not, since is on premise and has 300+ columns, send an http request is my only path.

I was able to figure out the send http request to hit the user information list, so I think I am good.

For future folks, to get from the internal ID of a user to their user data for on prem, use the "Send an HTTP Request to SharePoint" action:
Site address: Use your sites URL
Method = GET
Uri = _api/Web/SiteUserInfoList/items?$top=1&$Filter=Id eq 'yourVariable with the userID'

Of course, you will need to perform a Parse JSON after to get the values you are interested in.