Answered

Power App Portal with SharePoint List

(0) Share

Report

Posted on by Ahmed-Alsuhail

We are currently working on building an external facing app, the apps pulls the data from a SharePoint list. We are aware that you have to give access to the SharePoint list in order for the users to read/write to it through the app. So I have a couple of questions that I need help with:

1) Does the use of the portals change that? i.e.: if we are using portals with external users, can they use it to read and write to the SP list without having access to it?

2) If they must have access to it in order to use the app, can you suggest a free/low cost solution that works with portals and allows the users to use the app without access to the database? (CDS, Dataverse, etc...)

Thanks

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (1)

ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report

Hi @Ahmed-Alsuhail ,

The answer is

1. For your external - they have to be authenticated to achieve your needs. Anonymous access won't work because it requires Web roles set up in addition to SharePoint permissions. Please check the following official docs especially step 5.

https://docs.microsoft.com/en-us/powerapps/maker/portals/manage-sharepoint-documents

2. Portal is tied up with Dataverse so you need to pay at least a per-app license to get this solution working.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Ahmed-Alsuhail 10 on at

Like (0)

Report

Thanks @ragavanrajan, I will probably need to take up some learning to understand the 2nd answer as I am completely lost on how portals work. However, regarding the first one, if we authenticate the user to the app and SharePoint, is there a way that they we don't give them access to reading the data in the SharePoint list if they somehow find the link to it? It is a security concern we have even though it is unlikely someone can guess the link. I know this is not possible using the free PowerApps but because we are using portals thought there might be a way around it or is using a data verse solve the problem you think? i.e. they can use the app but don't have access to the database behind it

Was this reply helpful? Yes No
Verified answer

ragavanrajan 7,044 Most Valuable Professional on at

Like (3)

Report

Hi @Ahmed-Alsuhail ,

Externals should be authenticated via B2C or B2B or through local login to make this solution work. just keep this in your mind when you want to implement it.

Yes, it is possible through PowerApps Portal Web roles and entity permissions. Please have a look at the below article.

https://readyxrm.blog/2019/08/26/powerapps-portals-how-to-hide-or-show-content-based-on-logged-in-user/

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No