cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Re: End Users receive pop-up asking for permission when launching Power Apps

I have a Service Account which we assumed would be included and configured in the connector - Obviously we can't pass out credentials... Has anyone found a workaround?

...

Highlighted
Advocate I
Advocate I

Re: End Users receive pop-up asking for permission when launching Power Apps

I have a bit of a workaround that I use, it's not great but it works for certain situations. What I've noticed is that if you create a PowerApp as a Sharepoint list form and then have the flow act when the list item is created, there are no permissions prompts for the end-user. This means I can at least capture the username, use the flow to pull information from the database, and then put this information either in another list or simply email it to the relevant parties. This is only one-way information flow however, I cannot return information to the PowerApp. I really hope this is resolved, there are several workflows that would be dramatically simplified if this happens.
Highlighted
Advocate I
Advocate I

Re: End Users receive pop-up asking for permission when launching Power Apps

I wish we could get some more clarification on whether Microsoft plans to address this.

 

There are very many processes we would love to automate with our current toolset, but we are limited to only pushing data and not pulling into the PowerApp.

Highlighted
Advocate II
Advocate II

Re: End Users receive pop-up asking for permission when launching Power Apps

Please post link to your idea-post so we can easily find and upvote it. ...this UX is a deal-breaker for use of PowerApps

Highlighted
Advocate I
Advocate I

Re: End Users receive pop-up asking for permission when launching Power Apps

Highlighted
Advocate II
Advocate II

Re: End Users receive pop-up asking for permission when launching Power Apps

Thanks, I've upvoted the idea, and expanded on it to suggest a toggle-on-off control from PowerApps Admin Center.

In the mean time I've found a PowerShell solution but it is extremely cumbersome. PowerShell Cmdlets for PowerApps are here: https://powerapps.microsoft.com/en-us/blog/gdpr-admin-powershell-cmdlets/

What makes the PowerShell solution frustrating is this:

 - To activate "PowerApps Connection Direct Consent Bypass" the PowerShell cmdlets must be run EVERY the first-time the PowerApps form is published.

 - To successfully execute the PowerApps cmdlets the user must be an o365 Global Admin, the PowerApp Owner/Publisher, and the local machine Admin,

 - When executing PowerShell (as Admin) command "Set-ExecutionPolicy" must be run multiple times to defeat Global policies. The "Process" ExecutionPolicy must be reset each time the PowerShell instance is re-opened.

 - PowerShell ISE freezes shortly after running any of the PowerApps commandlets.  (this maybe a local issue for me)

 - The cmdlet authenticating into PowerApps throws an error when running in a Server 2012 environment. Win10 appears to be the only environment where authentication is possible.

Good luck

Highlighted
Advocate II
Advocate II

Re: End Users receive pop-up asking for permission when launching Power Apps

BTW - the magic PowerApps cmdlet in PowerShell is... 

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

View solution in original post

Highlighted
Frequent Visitor

Re: End Users receive pop-up asking for permission when launching Power Apps

I'm runnuing into the same situation where users are required to allow the app created with PowerApps to use SharePoint as data source. Our Office 365 Tenant Admin did run the cmdlet as follows, but failed to get the result of bypassing the user consent (to use SharePoint as data source) as expected.

 

Set-AdminPowerAppApisToBypassConsent -AppName d96d466b-ee1b-43a1-bbe4-xxxxxxxxxxxx

 

My app had been published for many times before the cmdlet was called and we did get an Ok message after running the cmdlet.

 

I'm struggling to get rid of this deal breaker in hitting my deadline to delilver the app.

 

Appreciate it if anybody can shed some light.

 

Fingers crossed.

 

Regards, Jake

Advocate II
Advocate II

Re: End Users receive pop-up asking for permission when launching Power Apps

Looking back at my notes, I was successful executing the PowerApps cmdlet using a role that was both the PowerApp  publisher and o365 Global Admin.  If your command execution result is "code: 200. description: OK" and your users are still  receiving the consent-prompt I recommend double checking the GUID to confirm you are executing against your most recently published version (GUID can change) then I'd ask your o365 admin to temporarily provide the publishing account with "Global Administrator" rights, he can revoke those priv's after successful execution.

Good luck.

Highlighted
Frequent Visitor

Re: End Users receive pop-up asking for permission when launching Power Apps

Hi Neville,

 

Many thanks for your prompt reply. 

 

I did check the GUID of the app and could not find any difference.

 

Per your suggestion, I'd talk to my o365 Admin in providing the publishing account with "Global Administrator" rights. Prior to doing that, may I know if this process, if it works, is needed just once and for all for the same app or an exercise required every time the app has been publilshed?

 

Jake

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,766)