I have SharePoint list that I customized in Power App. I have run in to a slight permissions issue.
Product: A list where employees can submit a leave request or the request can be submitted on behalf of the employee.
Permission Goal: I do not want all employees to be able to see all SharePoint list items. Only the following people should be able to see what is on the SharePoint list.
Plan: I will filter out all items unless the user is listed in one of the 3 following fields:
Question and Problem: Trying to set the value in the Controllers column to multiple SharePoint groups. As stated the Controllers column is hidden on the SharePoint list and in the Power App but I want the value to be automatically set to 3 SharePoint Permissions groups (group names would be Leave Request Managers, Leave Request Admins, Leave Request Auditors) The SharePoint Groups use Web Enabled Security Group Emails.
How can I accomplish this?
Unfortunately, Sharepoint lists must be shared with anyone using your app, and there isn't column-level access restrictions. You can make it a bit difficult for people to see, but you won't keep them out of the data completely. If security is a big concern here, you should choose a different back end.
Thanks for the reply. Understanding I can't completely restrict things, is there a way to set the value of a person or group field to those three SharePoint groups either in Power App or using flow?
There are two primary ways to manage some roles with Sharepoint lists:
I like method #2 because if a person is savvy enough to find the list used in method #1 then they are also capable of modifying the contents to their liking. Method #2 requires a level of admin access to alter the 365 Groups.
Ok let me ask a different question.
How do set the value of a person or group field to a specific SharePoint group in Power App instead of a specific user?
I am unsure if you can do that. I know you can set a People and Groups column to a 365 Group or individual users, but those are different entities than a Sharepoint Group.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.