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

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
Memorable Member
Memorable Member

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!

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

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,527)