Skip to main content

Notifications

Community site session details

Community site session details

Session Id : pVRgTh2YKThd5t2PF9OGWy
Power Apps - Building Power Apps
Unanswered

Canvas app and SQL connection reference

Like (0) ShareShare
ReportReport
Posted on 10 Mar 2023 09:33:09 by 25

Dear Powerapps experts,

 

I am trying to understand on how to best use the connection reference in canvas app. The MS documentation has very limited details about the use of connection reference in Canvas app. Need your advice on the following - 

 

We are moving few of our existing apps and flows to solutions and we are having issues with the SQL connection references, especially for the canvas apps.

 

1. The connection reference is only created when we add a new SQL connection to the canvas app. If we use an existing connection to add SQL tables to the canvas app, the connection reference does not get created. Does this mean that we must create a new SQL connection for every app even though we use the same SQL tables.

 

2. We have also noticed that if we do not add a SQL connection reference to the app, a SQL connection reference is automatically assigned from the pool of available connection references. This causes the missing dependency error when we import the solution to another environment. Is this the expected behaviour ?

 

3. When we update the connection for a connection reference, the connection is not updated in the canvas app. Is this the expected behaviour and how can we mitigate this ?

 

Thank you.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard
Loading started
Loading complete