"Get File Properties" - Permission denied due to missing connection ACL: Connection

Hi all,

I want to pull my hair out with this flow.

I fixed a problem with the dependent flow and it ran fine for half a day, then suddenly the parent flow runs into an issue.

I have a "get file properties" step (sharepoint connector) that was working perfectly for several days, even when other parts of the flow were broken. I saw that all end users were able to use the flow yesterday. At around 9 PM, it just stopped working.

Permission denied due to missing connection ACL: Connection

Sometimes when I try to resubmit a flow it will say this:

Request to Azure Resource Manager failed with error: '{"error":{"code":"InvokerConnectionOverrideFailed","message":"Could not find any valid connection for connection reference name 'shared_sharepointonline_1' in APIM header."}}'.

I am at a loss. This is a mission critical flow that has just had error after error that ran for almost a year until this week everything broke.

I deleted the entire sharepoint connection in power automate, remade the sharepoint connection, nothing, still have an error.

Please let me know what I can do, I am at a loss.

Categories:

Business Process Flows

Hi,

I suspect the permissions (either user or library) have changed recently and is the root cause. That's why it runs successfully (those that have the appropriate permissions) and fails for those that don't. So while it's a problem with Power Automate, it seems to be more about SharePoint permissions that anything else. Here's a few things to check - also do a root cause analysis and find one flow run that was successful and one that was not. Verify the permissions for each user.

If the flow stopped for everyone at 9 PM last night, it's most likely because someone changed the permissions for an entire group (guessing) or the library in question. Hope this helps:

Here are steps to troubleshoot and resolve this issue:

1. Verify Permissions

Ensure that the user account used for the connection has sufficient permissions to access the SharePoint site and the specific file library.

SharePoint Site Permissions:
- Go to the SharePoint site.
- Click on "Site permissions" from the settings gear icon.
- Check if the user has at least "Read" permissions to the site.
Library Permissions:
- Navigate to the specific document library.
- Click on "Library settings" from the settings gear icon.
- Under "Permissions for this document library", verify the user's permissions.

2. Re-establish Connection

Sometimes, re-authenticating the connection can resolve permission issues.

Go to Power Automate.
Click on Data from the left menu, then select Connections.
Find the connection used in your flow (e.g., SharePoint connection).
Click on the three dots next to the connection and select Edit.
Re-enter the credentials and ensure the connection is successful.

3. Update Flow with Correct Connection

Ensure that the actions within the flow are using the correct connection.

Open the flow in Power Automate.
Edit the "Get File Properties" action.
Check the "Site Address" and "Library Name" fields to ensure they are correct.
Under the "Connection" section, make sure the correct connection is selected. If not, update it.

4. Check Access Control List (ACL)

Ensure that the connection has been granted the necessary access within the flow.

Open the flow in Power Automate.
Click on Settings (gear icon) for the action that is failing.
Ensure that the "Run only users" permissions are correctly set. The user should have access to the connection.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Quick Links

Leaderboard > Power Automate - Building Flows