web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Can't allow connection
Power Apps
Answered

Can't allow connection

(0) ShareShare
ReportReport
Posted on by 23

We had an old sql connection we replaced and removed from out apps. We then deleted the connector.  Now we can not edit our apps properly.  It want's our permission to use however the allow button is grayed out.  Recreating our apps is not an option.

Capture.JPG
Categories:
  • Verified answer
    v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @drobinson ,

     

    Please try to restore your PowerApp to the previous version to see if the issue is fixed.

    If not, try to export the app from power apps, comes down as a compressed folder (zip), extract the contents of the compressed folder (zip).

    In the root of the folder you will find a "manifest.json" in there is a "dependsOn":[] section, simply remove the unwanted parts.

    Then under --> Microsoft.PowerApps --> apps --> {someID} --> {someID}.json . Open up the json file and look for the section

    "connectionReferences":{} again remove the unwanted parts.

    Then save the modified files back the folder with the same names,then making sure the manifest.json file and Microsoft.PowerApps folder are in root, compress(zip) the folder back down.

    Import/Upload the compressed folder (zip) back into power apps.

     

    Hope this helps.

    Sik

  • TimNYC Profile Picture
    17 on at

    I am having the same issue that drobinson had. Exporting the app and manually removing the reference seems like a great idea, but when I try to export the app I get the error message "Could not find connection '4a0dxa184cva2448ccx9248cffdy727c' for API 'shared_sql'." I can't fix the app without exporting it, and I can't export the app without fixing it. What else can I try to solve this?

     

    Thank you,

     

    Tim

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 204 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard