cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
knives
Helper I
Helper I

The caller with object id does not have permission for connection under Api 'shared_sql' and failed during http send request errors

I am creating a simple flow using a service account that has all the correct permissions for both power automate and powerapps and all the relevant data sources.

 

I cannot test this flow in power automate and I cannot add the flow to powerapps. My manager is the only person who can test the flow and add the flow to powerapps.

 

I cannot understand why this is happening as I have had several other view similar flows that are using the service account > data source connection with no issues and have been able to add these to my powerapp with no problems. I understand that this is a permissions issue but I cannot understand where the issue is stemming from as it was working on Monday and suddenly stopped working yesterday. I was hoping that the issue would resove itself if left overnight as many other users have experienced but this doesn't seem to be the case.

 

I've gotten very far in creating this app and all the flows associated so re-creating this app and all flows is not an option.

 

Any help would be much appreciated

1 ACCEPTED SOLUTION

Accepted Solutions
knives
Helper I
Helper I

For anyone experiencing the same issue this is what we did to fix the issue.

 

We restarted the gateway which fixed the majority of the connection issues on their own. For those that did not fix with a restart, we went into the connections section:

knives_0-1596527309713.png

Unshared with everyone, including those who have edit permissions, so that only the owner is left and re-shared. Then went back in and re-added people with the correct permissions.

View solution in original post

5 REPLIES 5
so96ie
Frequent Visitor

I have the same issue too, 

All action under SQL Server option always fails. The 'Server Name', 'Database Name', and 'Table Name' input fields always show error 'Could not retrieve values. The caller with object id { objectid } does not have permission for connection { connectionid } under API "shared_sql"'.

 

I have been using power automate since June 2019, and never experienced this before. 


Please fix this error. 

Thanks

knives
Helper I
Helper I

For anyone experiencing the same issue this is what we did to fix the issue.

 

We restarted the gateway which fixed the majority of the connection issues on their own. For those that did not fix with a restart, we went into the connections section:

knives_0-1596527309713.png

Unshared with everyone, including those who have edit permissions, so that only the owner is left and re-shared. Then went back in and re-added people with the correct permissions.

AnotherRedbeard
Advocate I
Advocate I

I was having a very similar issue to this inside of a flow that was trying to use a SQL Server Connection, but it wasn't able to find the server and database all of a sudden.  Our problem was fixed by editing the connection and reconnecting to the database.  This can only be done by the owner of the connection.

 

Hope that helps someone!

HelpfulBit
Frequent Visitor

Hi,

 

It appears you've figured it out, but I've seen this a few times, with different connectors and decided to share what I've found is a common cause for flow connection references not working. https://helpfulbit.com/connection-references-caller-does-not-have-permission-for-connection/

If you find this keeps happening, the article migh shed some light on why.

 

This older article may also be helpful https://helpfulbit.com/upgrade-flows-to-use-connection-references/ 


Feel free to reach out with any questions.

 

Ryan.

Therese1
Regular Visitor

I got this same error while trying to Export a Canvas PowerApp.  The issue turned out to be a Flow/Power Automate that no longer existed was referred in the Canvas App.  Deleting the extra Flow fixed my issue. Hope this helps someone. 

 

 

Therese1_0-1639000704567.png

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (2,024)