Frontend/Backend Access - SharePoint

(0) Share

Report

Posted on by CameronTCD

108

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CameronTCD 108 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CameronTCD 108 on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No