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.
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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.