BadRequest for grant access to an item or folder

[slvedva]

Hi,

Does somehow can help with my flow error: BadRequest for grant access?

I have flow, which create ~400 excel files and for each excel file system grant access to specific email and always somewhere in mid of process flow run failed with error BadRequest in step, when grant access to file. Where can be the problem?

[BCBuizer]

Hi @slvedva ,

Try adding an Ensure User step before the Grant Access action in your flow to make sure the user(s) you are granting access to exist on the site: https://powerusers.microsoft.com/t5/General-Power-Automate/Ensure-user-method-in-Flows/m-p/1631221/h...

[slvedva]

Hi @BCBuizer 

You mean, before this my step - "Grant access to an item or a folder 2" to add this HTTP request?

[BCBuizer]

Hi @slvedva ,

Indeed, that's correct.

[slvedva]

Hi @BCBuizer 

1. In Site Address I put my SharePoint address?

2. In the body at the end I put user name, which run this flow or ?

[slvedva]

@BCBuizer additional I grant access to the files, not for users, which are members of the SharePoint site, but users, which exist in my SharePoint list, these users I read in the first step "Get list for Sending".

[BCBuizer]

Hi @slvedva ,

Indeed for site, you give the site address: "SiteName.sharepoint.com". In case you are using environment variables, reference that.

In the body you use the exact text as in the example, but replace the dynamic content with your own which should give the UPN (email address) of the user you want to grant access to. Assuming 'Apply to each 2' loops through all items from "Get list for Sending", this should be something like:

@{item()?['User/Email']}

The above assumes you have a Person type column in the SharePoint list, you use for listing the users that need access, called User. 

In case these assumptions are wrong and you need support with getting the right dynamic content, please share the correct name and type of the column with the user information in it.

[slvedva]

Hi @BCBuizer 

I tried include this user from sender list, but I always receive failed and reason, that system didn't found the user.

All users for which I grant access are not specific SharePoint users, I share only link to specific file to specific user and user I take from SharePoint list.

[BCBuizer]

Hi @slvedva ,

Can you please share the body of the HTTP action? It seems like you tried ensuring a blank user.

[slvedva]

Hi @BCBuizer 

Here is my step with body. 

[BCBuizer]

Hi @slvedva ,

Thanks, I was actually referring to the flow run you posted that failed: what did the body of this action look like when it was passed to SharepPoint, i.e. the input of the 'Send an HTTP request to SharePoint' action. This should reveal whether the email field was blank or not.

[slvedva]

Hi @BCBuizer 

Here data from failed run:

[slvedva]

Hi @BCBuizer 

I found the reason, why I get this error, here is reason:

"status": 400,
"message": "You cannot share with more than 200 external users per hour. Please try again later.\r\nclientRequestId: d56cc12d-bfd9-442b-9f2a-287abaa8cb38\r\nserviceRequestId: d56cc12d-bfd9-442b-9f2a-287abaa8cb38"

Do you know, is it possible to change this limitation, because I should grant access to more then 400 external users?

[BCBuizer · Accepted solution]

Hi @slvedva ,

This is now sounding more like a SharePoint question than a Power Automate question. I tried looking around, but couldn't find anything similar posted on the internet.

I suggest you try asking this question in the SharePoint community for a better chance of finding a solution: https://techcommunity.microsoft.com/t5/sharepoint/bd-p/SharePoint_General

[Sidhant_02]

Hi @BCBuizer , @slvedva ,
I am facing a similar issue wherein I have created custom access to SharePoint list items for which I have used the grant access, the flow looks like:

And for some items the grant access failed (8-12 items)

The list contains around 2600 records. So in the grant access I am granting the user and his manager the access (and if the Manager's RM is present then giving the view access which are the next set of actions after grant action), so I did add the 'Send HTTP request action: ensure' which looked like something like this:

As there are 2 items I have used ';' i.e. in between 'Email','ReportingManagerEmail'. So is the above action correct?.
The other thing that I wanted to ask what does the 'Send HTTP request action : Ensure' do ?

Regards,
Sidhant.

[Sidhant_02]

Hi @BCBuizer & @slvedva ,
Have created a post on the Power Automate forum wherein I have provided more details about my issue, if you guys can have a look it will be helpful
My Post 

Regards,
Sidhant.