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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,061)