How To Assign Unique Permissions To SharePoint List Items
HTML-код
- Опубликовано: 11 июл 2023
- A short tutorial how you can easily assign unique permissions to SharePoint list items using the 'Person or Group' Field and PowerAutomate.
More information and blog tutorial here: liam-robinson.co.uk/sharepoin... 
Наука
It took me a while to find someone teaching this. Thank you very much
This is exactly what I was looking for. Thank you and thank God Jesus
Glad we could be of assistance.
This is helpful! Subscribed I want to watch more of your creative creations. ❤
Thank you. Was looking for something like this.
Thanks, this is what l was looking for
No problem. Please subscribe to keep in the loop with my latest posts :)
thats an interesting one
Thanks!!
Hi. Cool stuffs you did here. Keep it up!
I have this specific scenario.
SP Listing with 20 items with people picker column.
Admin will be assigning 10 items to Person A and 10 items to Person B.
Using power automate, I am capturing the changes for each of the item and grant access to the respective person.
The concern is both Person A and Person B will be notified 10 times in email.
The request here how do we send the notification only once per day? Case being, only alert when assigned that day only once?
You could probably set another flow up to run on schedule each morning, checking if a column has changed using 'get HTTP request', if it has then send email to 'Person field' email address to alert them they have things assigned to them
What if you want to grant permissions based on approves from another list?
Hey brother , can we make flow for column level permission? I am facing issue in List where i have two branches, Br1 should have all the access to the item but Br2 only have access to attach file and comment. Can we do this?
Unfortunately not, you can only assign permissions to the items not the columns. You could create a custom form in power apps however this would still allow people to see the content via lists, if it’s not confidential it would work but it’s not best practice.
@@liams-tech thanks !
Is there a way to only allow people to edit a certain column, whereas other columns will not be editable?
There’s not currently a way to achieve this, you could create a custom form in powerapps and only show this column, which would work but they would still have access to the item in the list, Linda like security through obscurity. If the data is not confidential it would work, but not best practice.
@liams-tech I see, but I need people to be able to view all the other columns. Basically I'm trying to make a way for a group of people to post certain taskings/projects they are assigned, and in which they would need a few volunteers to help out in. So someone will post a tasking as a list item with details in the relevant columns, then I want a way for people in the organisation to view the various taskings posted, and a few interested people (eg 2 or 3 people) simply register their interest/availability to help out in a particular tasking.
Do you know some ways I can achieve this? Or other m365 apps that would be useful
Doesn’t see to work if multiple people are in a people picker
Need solution for this
Did anyone solve this?