web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Can't connect to SPO c...

Power Automate

Answered

Can't connect to SPO custom user profile property via HTTP Request

(0) Share

Report

Report

Posted on by spela3

6

I'm trying to connect to the SPO user profile properties to retrieve a custom property via the "Send an HTTP request to SharePoint" connector.

The request is:

/_api/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?%40v='{Employee Claims}'

where the dynamic content "Employee Claims" displays i:0#.f|membership|user@domain.com to populate the accountName,

however the flow continues to fail with the error, "The query string "accountName" is missing or invalid."

I've tried '@', '%40' and still no luck. What am I doing wrong?

If there is another way to successfully get the SPO user custom profile properties (not Office 365), your help is greatly appreciated.

I need this information for the conversion of multiple SPD workflows to Power Automate.

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @spela3,

You can try this uri:

/_api/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?@v='i:0%23.f|membership|xx@siteurl.onmicrosoft.com'

Run result:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
spela3 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-litu-msft!
I escaped the '#' and the '@' and used "Employee Email" instead of "Employee Claims" and it ran successfully!
However, I'm getting a null output. Any ideas as to why?

Was this reply helpful? Yes No
spela3 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, I was able to get an output of the properties with this formatted request. Everything works now. 🙂
I also had to escape the ':' and '|' so that the format was "@v='i%3A0%23.f%7Cmembership%7C<accountName>".
I don't know if the headers were necessary, but I threw them in just in case.

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @spela3,

There is no need to add the headers.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ Lin Tu

Was this reply helpful? Yes No

Join the conversation