cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Singh2021
New Member

How to provide different user permissions to columns in powerapps

Powerapps experts, We have a SharePoint list and need to modify the form using powerapps (or) Power Automation as per below conditions. Can anyone, please suggest me and highly appreciate. 

 

New form -> It is open for all users. We are just need to grey-out(not to hide) two columns -  "Comments" and "Priority" column.

Once 'Submitter' submit the form, it should go to 'Supervisor' to provide 'Comments'. Only Comment column should be editable to 'Supervisor' rest all columns should be grey-out

Display form -> After 'Supervisor' provides comment, the form will go to the 'Submitter(who has submitted the form)' to choose 'Priority Accepted' column.

1. If acceptable - then all the columns need to be grey-out for everyone except 'Administrators'.
2. If Need further Clarification- form should be editable for administrators, 'Submitter' but 'Supervisor' can edit only 'comments' column rest all grey-out

Note : For administrator - form should be editable all the time.

1 REPLY 1
zaphod88
Responsive Resident
Responsive Resident

You need O365 grous or security groups for Supervisors and Administrators. In this thread here you can find how to look up which group a user is member of:
https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-Restrict-users-to-view-the-Screens...
When you have set up those groups, you can use them for changing permissions, e.g. in case of Administrators, you can set the following formula for your Comments input:

If(Or(
      User().Email in Office365Groups.ListGroupMembers("AdminGroupID").value.mail,
      User().Email in Office365Groups.ListGroupMembers("SupervisorGroupID").value.mail &&
       ChkPriorityAccepted.Value = false,
      ),
      Edit,
      Disabled)

ChkPriorityAccepted is your 'Priority Accepted' column assuming that it is a checkbox/boolean column.

If you are struggling with this or you need further help, it may be a good idea to screenshot the column list of your SP list in List preferences.


Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,811)