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....
Thanks so much. I've been trying various things, short courses, Microsoft KBs and this was the most helpful video. Easy to understand and the explanation was great.
This is cool. Thank you. I typically just hide buttons or items where staff should not edit in Power Apps and allow isManager to see everything. My concern for my situation with global staff and smaller Manager pools per regions in NA, EU, AOA, and LATAM is if a staff member leaves the company (all contractors)...This puts the burden on Manager to add a new staff member and how will they get access to manage their entries? I need to think through the scenario here and see how I can apply it for my use case.
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
@@rolaogomes just edit permission on the list, then when the item updates it “removes all permissions” and reapplies only the people specified so users can only see the ones they have created or at “assigned to”
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.
Good Day and thank you for this video. Is it possible to have no one see what others have entered except the owners or managers? I have list that I created a form for, however, when a person enters information into the list, I only want them to see their own items and not any items that were entered by another person. Does that make sense?
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