Deleted SQL connections - App not working

[Lefty]

Hi,

I'm in a sticky situation. I was tidying up my app as I had lots of redundant SQL connections, I deleted them both from my Connections tab in the environment and also deleted them from inside my solution. I had another service account I was asked to use hence why I did this.

As a result I am no longer able to use my app. I have done the following:

Created a new connection to SQL from 'Connections' using the old service account

Attempted to edit my app when this box appears, which I cannot click 'allow' as its greyed out, so I click 'Dont allow' :

and I add my connection in the app and connect to all my SQL tables using the same old service account. The app in edit mode accepts all the connections and functions.

When I attempt to go to the app URL in normal mode I get errors, even though I have published the app, and put a label on screen to show v11, it still only shows v10 no matter how many times I refresh and how long I wait.

When I attempt to go back to edit mode, the 'Allow' 'Dont Allow' box re-appears but I still cannot click 'Allow' this seemed odd too.

Any help will be appreciated

Thanks

[iAm_ManCat]

Could you try the following:

delete all SQL connections in that account's connection (from make.powerapps.com), then don't recreate yet.

Click to edit your app, Click Don't allow, then when in edit mode, delete all connections to SQL from the data connections via the data icon, save, reload, should not get asked for allow/don't, add sql data source to app (creating a new connection in the process by entering the details when you add the connection in the app), save, reload

[Lefty]

@iAm_ManCat 

Thanks for responding, I went through some major things to get the app working again, couldnt even try to list the steps as it was trying everything.

I need to clean up the connections, so I will create a back up of the app, and then attempt to follow your steps in the next coming days

Thanks

[Lefty]

Hi @iAm_ManCat 

Just attempting this. I have gone to make.powerapps clicked 'Don't Allow', removed each and every connection (by clicking on the data icon), including all SQL as well as Office365Users (as strangely that was not connected either). Saved a copy of this app, closed, went back in, into make.powerapps and still being prompted to allow/ dont allow, as you can see all I have now are collections when I click data:

 Saving a copy and closing and re-opening this copy i get prompted with the below

Edit:

Any ideas/further suggestions to try please?

[iAm_ManCat]

Wow, ok, that is unfortunate - those should have been deleted. This likely means they are contained in the references file of the .msapp and keep getting pulled back in.

There's a hacky workaround we can do by opening the .msapp file and modifying contents in a text editor, but before we do that let's try one last thing:

Do as you did before, edit, remove all connections,

then Save as a new App.

back to make.powerapps.com

export that new app.

(when doing the export, it shouldn't ask about sql connections in the bottom section of the export window)

then back to make.powerapps.com

import the app we just exported, give it a new name when importing.

edit this new New app, shouldn't prompt for sql connections.

If it does ask for them again, let me know and when I'm done with work today I'll write up a how-to for removing those connections from the .msapp file and for repackaging it.

[Lefty]

@iAm_ManCat 

Thanks, removed the connections, saved a copy of the app, closed it, went back to make.powerapps and clicked export and presented with an error I have never seen and doesn't look meaningful at all, as cannot understand what the IDs represent. 

I've partially removed the ID's incase there company giveaways:

[iAm_ManCat]

Ok, yeah that actually looks like something has gone wrong with the connections on that App - that will prevent my alternate solution from being an option.

This might need a support ticket raised with Microsoft via either your admin portal or support.powerapps.com

[Lefty]

I see, Thanks

would it be worth going to the source environment where I created this app and trying your suggestions there, I clearly have messed up somewhere from creating the app, to exporting it, to importing it?

[iAm_ManCat]

Yes, didn't realise that was an option, definitely try that if you can 🙂

[Lefty]

Hi @iAm_ManCat 

I have just deleted only a couple of SQL connections from the connections tab on the left in make.powerapps.com which claimed to being using in my app, but they shouldn't have been as I am not using that SQL DB anymore in that app, but deleting those 2 connections (to the same DB) I now get an error when I attempt to open the app in normal mode:

The app didn't start correctly. Check that you are online, and try refreshing your browser.

The connection definition is missing or invalid.

Session ID: d2165b06-xxxxxxxxx

Any ideas on this? doesn't make sense as I am not using this DB in my app, yet it's unable to load now, well any of my apps in that environment that were using this old SQL DB, even though I created a copy of the app, all apps made from the original one no longer work.

I do have Flows which call stored procedures, but they they should not be using this SQL DB too as it doesn't contain the data... although I did start off in this app with this DB but then changed over to different ones

any ideas?