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 / Question about SQL Con...
Power Apps
Answered

Question about SQL Connection and Connection References

(0) ShareShare
ReportReport
Posted on by 38

Hello,

 

I originally created an app of mine using SQL Server Authentication as the connection type. About 2 months later, I am told I need to change this because it is an implicit shared connection. How do I change this to Azure AD Integrated?

The steps I have taken are:

-I have removed (deleted) the old connection using SQL Server Auth.

-I then added a new connection using Azure AD Integrated.

-Using this new connection, I used it to re-add all my SQL DB tables. This worked fine.

 

However, when it came to the 14 Power Automate Flows I had, they got all messed up with the connections, connection references, etc. I just deleted and redid all 14 of them, and used the new, same Azure AD Integrated Connection, which it then prompted me to use a Connection Reference. I clicked the link, and it worked, after a few hours, all 14 working again.

 

However, when I closed and re-opened my app, I am greeted with this screen:

error.png

It seems as if it is still trying to use my old connection. Sure, I click "Ask for Access", but the link is dead and will not work. This comes up when I try and use the link:

error2.png

 

My initial thought was to click "Don't Allow" which I do, and it takes me to my app. All the data is loaded in fine, because its through the new Azure AD Integrated connection. However, all my flows are back to "Not Connected". 

I am extremely confused and anything helps.

Thanks!

Categories:
  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @mstrawn, just a thought, have you tried to edit the connection:

    991f70f4-24a6-46b3-ac3b-e369e08fc3ec.png
  • Verified answer
    mstrawn Profile Picture
    38 on at

    @AhmedSalih 

    I was able to figure it out by exporting my solution and then going through the XML files to discover ONE single table of mine was still using the old connection, even though on powerapps it said it wasn't. I simply removed that table and made sure to re-add it under the new Azure AD Integrated connection, and all is well.

     

    Thanks for the reply!

  • jvs6 Profile Picture
    4 on at

    Hello All,

    We are having issue in Preprod power apps.when we update in preprod app it is reflecting to prod database. can you please advise how to do it.

    advance in thanks.

     

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard