I've been having trouble with both my PowerApps connection & some flows. I had re-created my powerapp connection & flows earlier today and they again were working, however as of about an hour ago they stopped. I now see my connection is showing it was modified last week (vs 3 hrs ago when I recreated), and I recieve the following when trying to recreate my flows....
The caller with object id 'xxxxxxxx' does not have permission for connection '/providers/Microsoft.PowerApps/apis/shared_sql/connections/xxxxxxxxxxxxxx' under Api 'shared_sql'
I have checked & I have access (am owner) of the connection & the powerapp.
Solved! Go to Solution.
What is the connection your flow based on?
How is your flow configured?
I created a simple flow to test this issue, the flow is configured to get rows in SQL table when a button is clicked.
I can add the flow on a button on an app without errors.
When I clicked the button, the flow ran succeed.
Please show me more detail to help reproduce this issue on my side.
What’s your current situation?
Thanks for your screenshots. I create a similar flow to test this issue, I don’t get the error message you mentioned. The flow can be created without any error messages.
The error message is saying that you don’t have permission for the connection. Please check the connection on your side. Delete the old connection and recreate it might be a good choice. Please try it on your side to see if it will work.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.