cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CameronTCD
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
Pstork1
Dual Super User III
Dual Super User III

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
Pstork1
Dual Super User III
Dual Super User III

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.

@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. 

Pstork1
Dual Super User III
Dual Super User III

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

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)

Pstork1
Dual Super User III
Dual Super User III

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (92,306)