cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Frontend/Backend Access - SharePoint

Backend wise, I have a SharePoint that stores employee information.

The PowerApp, holds a gallery that filters using the following:

 

Filter('GDP Database',EmailAddress=LoggedUserEmail.Text)

 

 

So essentially, it will filter down to only show information of the employee using the app. 

 

The problem that I run into however is that it seems that an employee that logs into this app, cannot actually view any information, presumably because they don't have access to the source SharePoint. 

Is there any way to display the information without the user have access to the SharePoint?  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Frontend/Backend Access - SharePoint

The only real workaround is to modify the permissions on each item in SharePoint to secure them to the people who should be able to see them.  Power Apps users will have access to whatever they have access to in SharePoint. Power Automate can be used to change permission on an item when it is created or edited.  Or you can just modify permissions inside SharePoint



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

5 REPLIES 5
Highlighted
Dual Super User
Dual Super User

Re: Frontend/Backend Access - SharePoint

The user must have access to the backend data source in order to be able to view information in Power Apps. Power Apps has no capability to elevate or impersonate permissions.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper II
Helper II

Re: Frontend/Backend Access - SharePoint

@Pstork1 thanks for your confirmation. 

 

Is there a suggested workaround in this case?

The only reason that I cannot allow access to the source is that in contains sensitive information in regards to other employees. 

Highlighted
Dual Super User
Dual Super User

Re: Frontend/Backend Access - SharePoint

The only real workaround is to modify the permissions on each item in SharePoint to secure them to the people who should be able to see them.  Power Apps users will have access to whatever they have access to in SharePoint. Power Automate can be used to change permission on an item when it is created or edited.  Or you can just modify permissions inside SharePoint



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Highlighted
Helper II
Helper II

Re: Frontend/Backend Access - SharePoint

I'll provide an example and let me know if it's doable or not -

'john.123@email.com' logs into the sharepoint

John looks at the sharepoint list with over 500 entries of unique emails but can only see the items that contain his email in the email column

 

(i'm not that experienced with SP permissions & security)

Highlighted
Dual Super User
Dual Super User

Re: Frontend/Backend Access - SharePoint

Yes, you can filter the view in Power Apps.  No you can't filter the view in SharePoint.  If they go to the SharePoint list they will see all the records they have access to. The only way to prevent that is to change permissions at the item level for each item.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,604)