Power Platform Community Forum Thread Details

I exported an APP (not in a solution) from one environment (DEV) and restored it into another new environment (DEV). I then created a 'Solution' from the App in the DEV environment. I then ran into the problem noted below. However, two days later I was able to edit the app in DEV, without getting the App Permissions errors and the SQL showed as connected properly. Now, the next day, once again it gives the same access issue. Any idea on how to fi this? I have wasted days on this. Short of dropping ALL my connections (many dozens of them - all to tons of different SQL tables) and recreating them again, is there something I can do to get this to work? Not sure how it worked yesterday, but that was the only time it has allowed SQL permissions since moving to this DEV environment (I had admin rights to the environments). And, if I have to recreate all these connections, should I do it through Connection References? Not sure how much more work that will then be as well. The end goal is to be able to do development in DEV environment and then update the app in the PROD environment. So lost trying to get this in place and working. Losing days and days of time on this an not sure where to turn. Would appreciate ANY help! Thanks!