cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Super User
Super User

Prevent users from entering a value inside a SharePoint field if they are not inside a SharePoint group

We are working on asset management system inside SharePoint online, here is the scenario:-

  1. We have 2 SharePoint groups; Admins & Regular users
  2. Inside the Assets list we have a field named "Owner" of type people/group
  3. Now if the login user is not admin (is Regular user), then the Owner field should be disabled and auto populated with the login username.
  4. while if the login user is an Admin then the Owner field should be enabled and allow the admin to enter any owner.
Now i am not sure how i need to implement this to prevent regular users from entering values inside the Owner field other than their username ?So if we customize the SharePoint list form using Power Apps, will we be able to implement the above scenario ? of enabling/disabling the Owner field based on the user's permission inside SharePoint?
1 ACCEPTED SOLUTION

Accepted Solutions
Ashwin7104
Super User
Super User

Hey @johnjohn123 ,

 

There are numerous informative blogs and videos on this subject. Use the URL below that Reza provided as an example.

 

https://www.youtube.com/watch?v=dIzOAbMjN7g

 

Additionally, you can use Power Automate to call the REST service in SharePoint to determine whether a user is a member of a group and receive a Boolean value that you can use in PowerApps to enable or disable the column.

View solution in original post

1 REPLY 1
Ashwin7104
Super User
Super User

Hey @johnjohn123 ,

 

There are numerous informative blogs and videos on this subject. Use the URL below that Reza provided as an example.

 

https://www.youtube.com/watch?v=dIzOAbMjN7g

 

Additionally, you can use Power Automate to call the REST service in SharePoint to determine whether a user is a member of a group and receive a Boolean value that you can use in PowerApps to enable or disable the column.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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.

Users online (1,582)