how to use getUserEffectivePermissions api

(0) Share

Report

Posted on by CU17102127-0

HI!
i have been trying to use the _api/web/getUserEffectivePermissions(@u)?@u='i:0#.f|membership|username@domain.com' call using the HTTP SharePoint Connector. but no matter how i try the username I either get High and Low as 0.

If I try a variation of the call: _api/web/getusereffectivepermissions(@u)?@u='principalName=username@domain.com i get the following error:

"status": 404, "message": "The user does not exist or is not unique.\r\nclientRequestId: b2a9c995-f221-4818-99ac-2ce4ece48234\r\nserviceRequestId: 1ce75aa1-50a9-6000-8644-061becf7455b", "source": https://[tenant].sharepoint.com/sites/[site-name]/_api/web/getusereffectivepermissions(@u)?@u='principalName=username@domain.com', "errors": [ "-2130575276", "Microsoft.SharePoint.SPException" ]}

has anyone been able to do make this call work in Power Automate?

Categories:

General topics

All responses (3)

Answers (0)

Sort by

Suggested answer

Ellis Karim 12,288 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Doing a bit of reading, please try the following
_api/web/getUserEffectivePermissions(@u)?@u='@{encodeURIComponent('i:0#.f|membership|user@yourdomain.com')}'",

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!
karolmax 92 on at

Like
a
(0)

Report
Copy link

Link copied!

But how you can work with your outcome/results later? You Received 4294705151 as a low value If I create condition action after this step to check if outputs contain "4294705151" it is not working as expected. It will not give me true when value is present and false when there is different value.

UPDATE, just create variable - I was using compose but it was not recognized
Suggested answer

Ellis Karim 12,288 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
If you look at the outputs for High and Low you will see that they are returned as text strings:

To get the High and Low values, use the following expressions:

outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['High'] outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['Low']

To get the High and Low values, and convert them to integers, use the following expressions:

int(outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['High']) int(outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['Low'])

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!