cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
espenjor
Helper II
Helper II

Need to accept connection everytime app is opend

An earlier error from 2020 has resurfaced. Users are prompted to accept the use of SQL every time the app launches. Is there a workaround or a fix in the near future?

4 REPLIES 4
PG_WorXz10
Resident Rockstar
Resident Rockstar

Hi @espenjor ,

 

You will require Office 365 Global admins or Azure Active Directory Global admin permission in your account.
 
Install Powershell module:
Install-Module -Name Microsoft.PowerApps.Administration.PowerShell
Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber
 
Get Power Apps APP ID from the Details screen of your PowerApps.

Finally

Set-AdminPowerAppApisToBypassConsent -AppName <YOUR_APP_ID>

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

You cant mean that we will need to use PowerShell to avoid the everlasting question about permission to use SQL or other connection in PowerApps every time a user opens it? 

Hi @espenjor ,

 

Yes, Asking permission is the default behavior of PowerApps you will have to BypassConsent  feature manually using PowerShell. 

 

 Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

Thanks for your time. Last quick question. If none of my other apps is requesting permission top SQL, position and camera everytime I open the app. Why is the one app question this?

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,313)