Answered

Access is denied

(0) Share

Report

Posted on by Community Power Pla...

I have a power automate flow which when i run from a modern sharepoint form (powerapps) is fine.

When other users run the flow which don't have permissions to write to the sharepoint list in sharepoint, the flow fails with

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
clientRequestId: 3681bb4b-6951-4c78-a102-f195a708034a
serviceRequestId: 3681bb4b-6951-4c78-a102-f195a708034a

I dont want to give the users access to the list in sharepoint but can i give the users access to the flow?

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Access is denied when the sheet is protected in excel online

Hi,
I get this error when I protect the sheets in Excel online file in the Sharepoint. The flow fails when the sheets (or particular cells) are protected, however when unprotected, the flow works again correctly. I have all the permissions (flow, excel online, it was also me who protected the sheets).

Could you advise me on how can I solve this?
Verified answer

CFernandes 8,283 Most Valuable Professional on at

Like (0)

Report

Re: Access is denied

@Anonymous Ohh. You might want to break down your Power Automate in Child and Parent Flow.

https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/power-automate/call-child-flows

and then Share the connections for the Child Flow.

One Important thing to remember Child Flow only works in you are using Solutions.

I am working on a similar solution and will share the details with you tomorrow(Its late in India so I am away from my PC)
Community Power Pla... on at

Like (0)

Report

Re: Access is denied

@CFernandes I don't have any visible options to add 'run only users'. All my users can run the flow. The flow creates a new record in a sharepoint list which the user that runs the flow doesn't have sharepoint permissions to create new list items, hence the question if the flow could be set up to run as a different user.
CFernandes 8,283 Most Valuable Professional on at

Like (0)

Report

Re: Access is denied

@Anonymous You can Share the Connection's by managing RUN only user.

I am not asking you to Share the Flow or make other user owner 🙂

From the article:
Managing run-only users
For triggers that support run-only users, you will see a Manage run-only users card just below the Owners card. Click the See all on the card.

Here you can manage the run-only users or assign the users of the SharePoint list as run-only users. This means users who have read permissions to that list will be able to run flows.

Here is an added bonus. You can also select the option for run-only users to provide their connection. This means that when the flow runs, the context of the user running the flow will be passed instead of using the connection configured in the flow. Very useful when you want items or documents created based on the user.
Community Power Pla... on at

Like (0)

Report

Re: Access is denied

Thanks @CFernandes

The user that runs the flow only has read only access to the sharepoint list in sharepoint permissions. i do not want to make all users owners of the flow. Can the flow be run as a defined user?
CFernandes 8,283 Most Valuable Professional on at

Like (0)

Report

Re: Access is denied

@Anonymous You might want to Manage Run only users.

https://www.chakkaradeep.com/2018/05/22/managing-owners-and-users-for-your-sharepoint-list-flows/#:~:text=Microsoft%20Flow%20allows%20you%20to,flow%20depends%20on%20the%20trigger.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!