I am trying to read and write item level security in sharepoint online with Flow. I have followed numerous examples. I have even used tenant admin to give tenant Manage permissions through the Sharepoint Add-in. I can successfully retrieve an access token, but no matter what combination of access permissions I give, Flow returns a Forbidden error when trying to read or update item level security.
I know that Flow uses the Sharepoint\App account, do I need to do something special with that account?
<AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="Manage" />
<AppPermissionRequest Scope="http://sharepoint/content/sitecollection" Right="FullControl" />
I post to "https://accounts.accesscontrol.windows.net/xxxx/tokens/OAuth/2"
I receive an access token
I use the token to post to https://xxxxx.sharepoint.com/sites/xxxxx/_api/lists/getbytitle('xxxxx')/items(1)/roleassignments/
I get Access Denied
I even get access denied if I try to get the site title ("https://xxxx.sharepoint.com/sites/xxxxx/_api/web?$select=Title")
What am I missing?
Thanks in advance
Solved! Go to Solution.
I'm using the HTTP connector.
Should I be using the "Send an HTTP to Sharepoint" connector?
I changed the HTTP connector I'm using to the Sharepoint HTTP connector and I'm starting to see some good results. I believe this may be the solution.
Thank you for pointing me in the right direction.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!