cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MattyJ_09
Level: Powered On

Bypass App Permissions for Google Sheets

Hello, I was wondering if anyone knew of a way to bypass the screen that asks a user to sign to google when using Google Sheets as a data source for an App?
2 REPLIES 2
Highlighted
seadude
Level 10

Re: Bypass App Permissions for Google Sheets

Hello @MattJ_09. I’m not sure it will work for Google Sheets, but there is a few PowerApps PowerShell cmdlets that bypass the “Allow” pop up. I’ve tested them for Sharepoint and OneDrive bypasses and they work well.
- it’s not for the faint of heart. You may need admin privelages and such.
- https://powerapps.microsoft.com/en-us/blog/gdpr-admin-powershell-cmdlets/

Good luck!
MattyJ_09
Level: Powered On

Re: Bypass App Permissions for Google Sheets

I've tried the following command and it didn't help.  I did get a sucess message in PowerShell but it still asks the users for permission.

 

Set-AdminPowerAppApisToBypassConsent -AppName put-the-PowerApps-GUID-here -ApiVersion 2017-05-01