Get list ID using SharePoint Rest API will raise this error "Permission Denied due to missing connection"

Question

I have a manual power automate flow that get called from a Power Apps, the mainly action is to return the list ID based on the passed list title, as follow:-

But a lot of instances failed due to "Permission Denied due to missing connection", although the users who called the floe has Read permission on the list, any advice?

Thanks

Answer 1

Hi @john john Pter ，

Good days, thanks for querying in this forum.

It sounds like you're encountering a common issue in Power Automate related to connection permissions. This error typically occurs when the required connection for a flow is not properly authenticated or lacks the necessary permissions.

Here are a few steps you can try to resolve this issue:

1. Verify Connections:

Ensure that all connections used in your flow are authenticated and have the necessary permissions. You can do this by going to the Data section in Power Automate and checking the status of each connection.

2. Re-establish Connection: Sometimes, re-authenticating the connection can resolve permission issues.
   1. Go to Power Automate.
   2. Click on Data from the left menu, then select Connections.
   3. Find the connection used in your flow (e.g., SharePoint connection).
   4. Click on the three dots next to the connection and select Edit.
   5. Re-enter the credentials and ensure the connection is successful.
3. Recreate Connections:

Sometimes, simply removing and re-adding the connection can resolve the issue. Delete the problematic connection and then create it again.

4. Check Permissions: Make sure that the user account running the flow has the appropriate permissions for all services and resources involved in the flow. You can let the user run the API command directly to see whether the list ID can be successfully obtained.
5. Check Access Control List (ACL): Ensure that the connection has been granted the necessary access within the flow.
   1. Open the flow in Power Automate.
   2. Click on Settings (gear icon) for the action that is failing.
   3. Ensure that the "Run only users" permissions are correctly set. The user should have access to the connection.

If these steps don't resolve the issue, you might want to check the Power Automate community for additional help.

Kindly consider accepting the answer if the information provided is helpful. This can assist other community members in resolving similar issues.