Answered

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

(4) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Team ,

I have created a Power Apps form to submit data to a SharePoint list. This form is shared with the whole organisation providing them with 'User' access on it.

Problem Statement : When any of the end user opens the form for the first time , they have to 'Allow' access as seen below. This is not user friendly and can be confusing for most non-technical users. Is there a way to allow this by default so that every user does not require to go through the pop-up. We have alreay given them the required access on the form and the list it connects to. We have SSO(Single sign on) enabled on the enviroment.

Your early response will be appreciated as we are planning to go live soon.

Thanks & Regards ,

Neha

Categories:

Building Power Apps

I have the same question (0)

All responses (50)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Neha,

It’s a default behavior. When you share an app, you are also asked to share your connections. Some resources are shared automatically, while other resources require shared users to take extra steps so that the app works as expected.

The first time shared users open the app, they are asked to sign in with their own credentials. It won’t occur the next time shared users open the shared apps.

Please check this documentation about “Share app resources” for more details:
https://powerapps.microsoft.com/en-us/tutorials/share-app-resources/

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks Mabel , the link is informative. I am using Power Apps to connect to SharePoint Online list. I tried to find the share connections options , but it is not visible in the connection to the SharePoint tenant used in the form. Does that mean this conection cannot be shared and has to allowed by every user accessing the form?

Cheers,
Neha

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Mabel Mao,

Is there any listing of connections that cause this popup

I would be keen to know as to avoid using them due to the poor user experience.

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Neha,

For you are using SharePoint list as your data source, to share this connection, you should go to SharePoint site to specify permission level to shared users. This documentation about “Edit and manage permissions for a SharePoint list or library” could be a reference for you:
https://support.office.com/en-ie/article/Edit-and-manage-permissions-for-a-SharePoint-list-or-library-02d770f3-59eb-4910-a608-5f84cc297782?ui=en-US&rs=en-IE&ad=IE

After you shared app and specified permission level for shared users, shared users need to create their own connections to the data source, then they would be able to access the app as expected.

So we could share apps on PowerApps. While to share the connections that cannot be shared automatically, you should go to the data source to find the proper way to share it with shared users.

Please feel free reply if you need more help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
JaredKing 47 on at

Like (0)

Report
Copy link

Link copied!

Hi, what does this mean:
"shared users need to create their own connections to the data source" - is this done when the user clicks Allow in the popup?

I have a user that gets a popup with 'Sign in failed' and cannot click allow. User has 'can use' permission in powerapps, and 'contribute' permission in the sharepoint site.

What else do i need to configure here?

Thanks!

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JaredKing,

Allow Access doesn’t mean that shared user has created their own connections, it means that shared user allows PowerApps to access the data source on their side.

To create their own connections, on powerapps.com portal, click Connections, then select SharePoint and create the connection with their own credentials.

About how to create a connection, please check this doc for a reference:
https://docs.microsoft.com/en-us/powerapps/add-manage-connections

Best regards,
Mabel Mao

Was this reply helpful? Yes No
JaredKing 47 on at

Like (4)

Report
Copy link

Link copied!

Thanks for your reply.

Oh dear...
I know how to create a connection - I have created one for the app (emphasis on I, not the target audience/consumer of the app)

Just to clarify, we cannot build a sharepoint list, build an app that references the list with a shared connection and deploy the app to multiple users (The permissions handled by sharepoint and Me sharing the app). Every user has to create a connector to the sharepoint list by using the PowerApps portal? Unless I am mistaken, that does not seem to be user friendly.

In my use case i have 30+ users (generally non technical) who must login to powerapps and create the connection? Please advise if there is a better way to deploy these apps.

Thanks

Was this reply helpful? Yes No
JRaasumaa 1,325 on at

Like (3)

Report
Copy link

Link copied!

@JaredKing wrote:
Thanks for your reply.

Just to clarify, we cannot build a sharepoint list, build an app that references the list with a shared connection and deploy the app to multiple users (The permissions handled by sharepoint and Me sharing the app). Every user has to create a connector to the sharepoint list by using the PowerApps portal? Unless I am mistaken, that does not seem to be user friendly.

I don't think that he means every user has to create a connection in the PowerApps portal, I've yet to see that behavior but I believe it's the initial "Allow" access screen that pops up when they first launch the App that he is referring to and should be the only thing a user has to click to continue on. This makes it a bit easier on someone accessing your app to know to just allow those connections and move on. If something else has to be created outside the App that's a completely unacceptable solution.

Curious what the response is, the responses have been unclear and quite the mess so far in this thread...

Was this reply helpful? Yes No
sirajmustafa 18 on at

Like (6)

Report
Copy link

Link copied!

Unfortunately it seems every user has to Create his/her own connection once. Not a good UX

Was this reply helpful? Yes No
Rolly 28 on at

Like (13)

Report
Copy link

Link copied!

Hi,

I have been working with PowerApps over the last little while given that Microsoft have given up on Infopath and don't really have a form solution (Forms (Preview) is all but useless). Suffice to say, it is completely unworkable to deploy a "forms" solution and expect our 900+ nursing staff to have to go through the confusing process of needing to sign-in to request permissions to access a basic sharepoint list. This should all be transparent to the user. We have access to 2 top Microsoft resources who are part of our fasttrack deployment process. I keep asking for Microsoft roadmap in terms of a forms solution but the best I get is a few blogs abour PowerApps. I have been trying to keep track of the multiple limitations with PowerApps to try and give some feedback to MS. It's not a finished product and doesnt work well with SharePoint. the bottom line is that any form solution should be easy to use and not require any addition login once logged into SharePoint nor any additional licence to be assigned which is another suprising limitation. Lastly, users outside of the organisation should be able to access a powerapp without credentials. The SharePoint connector should do all the permission brokering. We are going to need to go with a third party product I believe. You can waste hours and hours fiddling around with PowerApps and especially the specific licence and permission requirements. You will notice that when you embed a powerapp that it can take a while to load. This is because its doing an additional login behind the scenes even though a user would have already logged in. Not making sense right now. InfoPath just works. R

Was this reply helpful? Yes No