cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
opax
Advocate IV
Advocate IV

Sharing connections does not work: App wants to use these features dialog with disabled Allow button

I'm working on a PowerApp solution which uses Azure SQL database backend. After the GA, I saved the solution locally and then saved it to production (default) environment of the customer. I recreated the Azure SQL Server connection for production (default) environment. I shared both the PowerApp and the connection to the users. 

 

No matter how many times I retry this, the users are not able to click the Allow button in the dialog when they are trying to access the app from browser client.

allowed-button-disabled.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Have any of you experienced this and found a way around it?

 

There is actually additional strange behaviour here: There should be only one connection instead of two. But on the other hand, I have another app with only one connection (shared with the users) and that doesn't work either.

 

Please help 🙂

 

3 REPLIES 3
DaveB
Advocate II
Advocate II

I have been testing migrating apps from development to production as well. There are a few issues.

 

I found that I need to use Windows Studio to save/load apps from one environment to the next (all new environments/CDS databases). Using the Web Studio preview does not work it just hangs.

 

Once I have managed to save my app to the cloud (from Windows Studio, SQL azure connection), I cannot edit the app in Web Studio preview, though it will play. The error is:

 

ProductionAppNotFound.jpg

 

So at the moment that makes the Web Studio preview almost 'unusable' in real workflows. It only takes 10 minutes to test the scenarios for dev to production, so it is very easy to see the problems. I avoided attempting legacy-to-new on purpose, just new-to-new.

v-monli-msft
Community Support
Community Support

Hi opax,

 

Please make sure that you have explicitly shared the SQL connection from PowerApps.com (go to connections details view and click on the share tab) and then check the issue.

 

Regards,

Mona 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the replies. I'm still unable to make this work. The allowing of the connection simple does not seem to work to other users it is shared with. I'm trying get help from the product group.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,747)