Unanswered

CheckUserGroup Flow failing for one user only - BadRequest error in SharePoint connection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey,

Please hlep me find the cause why my flow fails, unfortunatelly errors shown don't tell me much. I use standard CheckUserGroup flow to verify if user belongs to Sharepoint Group, and only for one user it fails (I've reasigned user access to SharePoint group and compared his access and privileges to different user which has no issue with runnig the flow).
Here is what I'm getting when trying user is running the flow:

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,773 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Just to double check. You are using the Send an HTTP request to SharePoint action, correct?

What is the URI for the GET request you are using. The screenshot is missing part of that URI. Is it something like below?

_api/web/sitegroups/getByName('Group Name')/Users?$filter=Id eq 28

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for response, the URI is as below (and it works for 10 other people, only one user gives such an error every time he triggers workflow):
_api/web/sitegroups/getByName('SharePointGroupName')/Users?$filter=Email eq 'usersemail@domain.com'

Was this reply helpful? Yes No
Expiscornovus 33,773 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Is it possible that the specific user doesn't have an e-mail address in his SharePoint profile?

Can you check this by using this URI and check if the Email field is empty?

_api/web/sitegroups/getByName('@{variables('GroupName')}')/Users?$select=Id,Email,Title,LoginName

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus

I ran the URI you gave, and email field is filled with correct email address. What else can I verify?

Was this reply helpful? Yes No