Answered

Could not find connection 'cbaaf7feb51741fca497ac3d7566c5fb' for API 'shared_sql'.

(2) Share

Report

Posted on by Wosscr

Hey guys,

I'm having a problem with my PowerApp, the app is somehow retaining a SQL Connection that is no longer used and that I removed from the data sources. When I try to share the app with the users they get a message saying "This app needs access to this connection", the same thing happen when I try to export the app (trying to solve the error before), but then I get the "Could not find connection 'cbaaf7feb51741fca497ac3d7566c5fb' for API 'shared_sql'." message.

When looking in my SQL Connections, I can see that there is that one that I removed already from the PowerApp saying that it is still being used by the app.

PowerApps A.png

When I am on edit mode in the app, and I look at the Data Sources (View -> Data Sources), it is not there.

Any idea about how to solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Sort by

K-A-R-L 715 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Wosscr ,

You could try checking the apps using the connection on the connector itself. Open Powerapps then Go to File > Connections > Find your SQL Connector > Click Ellipsis (...) > Details > Apps using this Connection

or

Go to https://make.powerapps.com/ > Data Dropdown > Choose Connections > Find your SQL Connector > Click Ellipsis (...) > Details > Apps using this Connection

----------------------------------------------------------------------------
Thanks,
K-A-R-L

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Wosscr 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @K-A-R-L,

Yes, If I do that, I can see my PowerApp listed as one that uses that data source, which is precisely the problem I believe because I already removed it and is no longer available. If I go to View -> Data Sources in edit mode, I don't see it anywere, same thing if I add a control, say a data table, and try to connect it to a data source, that one doesn't show up. So I have no way to access it from my PowerApp, yet it says that is being used there. I don't know how to remove it so that I can share/export it.

Any ideas?

Was this reply helpful? Yes No
K-A-R-L 715 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Wosscr ,

It might be Cache problem, have you already tried deleting your broswer cache or try using different broswer and see if any of it works.

One odd solution is to PATIENTLY wait, eventually time will fix it.
----------------------------------------------------------------------------
Thanks,
K-A-R-L

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Wosscr ,

Do you mean that the connection you removed from your canva app still be used by this app?

Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side. I agree with @K-A-R-L 's thought, I think this issue may be related to the cache of connection within a canvas app.

As an fixed solution, you could consider remove the SQL connection from the Connection List in your PowerApps, then check if the issue is solved.

More details about removing connection from Connection List, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-manage-connections#update-or-delete-a-connection

In addition, if you want to get further help in this issue, please consier submit an assisted support ticket through the following link:

https://powerapps.microsoft.com/en-us/support/pro

Best regards,

Was this reply helpful? Yes No
Wosscr 34 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-xida-msft,

Thanks for the recommendations. I didn't want to do that (remove the connection from the list) because it was used in other flows, but I did it anyway to see what the outcome was, so I moved all the other flows to a new connection to the same data source, and finally removed the connection in question from the list.

Now, I try to open the PowerApp and this is the message I receive:

I cannot allow it because the connection is not present, so I click "Don't Allow" to go to the edit mode of the app and I see no errors, like if there was a missing connection or anything.

Any thoughts?

Was this reply helpful? Yes No
Verified answer

Wosscr 34 on at

Like
a
(2)

Report
Copy link

Link copied!

Here is an update on this matter.

I had a call with a Microsoft rep for about 1 hour, explaining what the issue was and after he saw it, no solution was found. I sent the fiddler traces, and because my issue was not urgent its level was lowered, 5 days later I'm still waiting for a response.

Even though it is true, it wasn't an emergency, is not that I could just wait forever for a solution, so what I did was to rebuild the app again, fortunately it wasn't a big app and I could replicate everything in about 8 hours. My advice is, be careful with what you add and remove as data sources as there is clearly something wrong with PowerApps at this point. If I ever get a response from Microsoft, I'll update this post.

Was this reply helpful? Yes No
LievenBoving 19 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello I'm facing the same problem. Can you fix it yourself or do you need support from MS?

Was this reply helpful? Yes No
Wosscr 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LievenBoving, I opened the case with MS, but they couldn't fix it, they couldn't replicate it.

In my case, the solution was to start an app from scratch and just copy over all the content. It worked for me because the app I had was in a very early stage, since then I've been exporting the app at least once a week in case this happens again.

Try exporting the app, I tried that and I couldn't because the connection is not found, but if you can, maybe you have more hope than me.

This is probably not the answer you expected. Sorry.

Was this reply helpful? Yes No
LievenBoving 19 on at

Like
a
(1)

Report
Copy link

Link copied!

@Wosscr : Thanks for sharing that with me.
There is a broken reference in the project structure. I need to ask MS :
Can there be a fix to remove the bad connections. It is very simple to reproduce. The blocking problem is not export, the problem is sharing with new users, new devices.

Kind Regards Lieven

Was this reply helpful? Yes No
m3ngi3 725 on at

Like
a
(1)

Report
Copy link

Link copied!

So... why is this one solved while there is no solution?

Working with multiple environments:
I managed to get the permission request go away by re-adding the connection, removing the connection, saving as a new PowerAppConnectorFree, exporting PowerAppConnectorFree, importing PowerAppConnectorFree to update already existing PowerApp --> no more permission popup request in already existing PowerApp in this environment.

However the already existing PowerApp is part of a Solution so when exporting Solution after all the above with this now correctly functioning existing PowerApp and importing the overall Solution in a brand new environment --> the permission popup request is back again 🤯

Was this reply helpful? Yes No