Hello, fundamentally this approach works. However, for "secret content," it is absolutely not suitable. In the time delta between the creation of an item and the execution of the flow, there will be, for example, a 3-minute window where anyone who opens the list during this time can see and read the item. From a data protection perspective, this is unacceptable. Even reducing the flow interval to 1 minute still leaves a 1-minute gap, which is too much. I already created a ticket for M365 and had a session with Microsoft, where they confirmed that there is currently no solution for this scenario. Do you perhaps have an alternative solution to address this issue? Antworten
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.
This is great but do you have something on restricting columns to edit? so in this case, i want the manager to have full control, but the staff can only view the title column but add comments and change progress bar etc. is that something you can guide on?
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
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?
@@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”
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
Thank you so much, this is very helpful. The whole internet failed to help me with this. But you had the solution in just 5 mins.
Glad I could help, if you haven’t already, please subscribe, hopefully I can help more in the future
This is exactly what I was looking for. Thank you and thank God Jesus
Glad we could be of assistance.
I'd also like to take some time to thank Teenage Party Animal Jesus and Holy Baby Jesus, this is amazing.
Hello, fundamentally this approach works. However, for "secret content," it is absolutely not suitable. In the time delta between the creation of an item and the execution of the flow, there will be, for example, a 3-minute window where anyone who opens the list during this time can see and read the item. From a data protection perspective, this is unacceptable. Even reducing the flow interval to 1 minute still leaves a 1-minute gap, which is too much.
I already created a ticket for M365 and had a session with Microsoft, where they confirmed that there is currently no solution for this scenario. Do you perhaps have an alternative solution to address this issue?
Antworten
It took me a while to find someone teaching this. Thank you very much
You're very welcome!
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.
You're welcome! Glad I could help.
Excellent content, simple solution and explanation. Just what I was looking for.
Awesome content. So easy to follow but yet so powerful. Thank you.
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.
This is helpful! Subscribed I want to watch more of your creative creations. ❤
Awesome! Thank you!
This is great but do you have something on restricting columns to edit? so in this case, i want the manager to have full control, but the staff can only view the title column but add comments and change progress bar etc. is that something you can guide on?
ohhh myyy days this is genius! What a game changer! thanks you my man- subscribed!
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
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 !
Thank you. Was looking for something like this.
Will this work using the "Allow Multiple Selections" for the manager?
Thank you man! Wish you Long Happy Life!
Thanks, this is what l was looking for
No problem. Please subscribe to keep in the loop with my latest posts :)
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?
yes, you can set it in Advance settings
What if you want to grant permissions based on approves from another list?
This is amazing! But what are your permissions for user within the list itself? Can they see all items? Or only items they have created?
@@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”
How can I hide the entire list? If I only want certain people to see the list itself--not everyone at the company?
@@maxsanemitchell1609 you can change the permissions on the list itself by pressing the cog icon and heading to permissions
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
very helpful
thats an interesting one
Doesn’t see to work if multiple people are in a people picker
Need solution for this
Did anyone solve this?
Thanks!!