Thank you for clarifying the issue with not being able to use SharePoint Group in the Recipients, this is what I was trying to figure out. This is really a huge downfall because most of these Lists I use for forms I want to make sure everyone in the members group still has rights to view after the approval flow is completed. There would be only a few select cases where I would want it limited to just the people involved in the approval process. Not being able to use groups makes this unsable for most of my applications.
thanks for the video. The flow works fine as explained in the video. There is one problem however, that the grant access flow does not grant permission to any attachments that are in the list item. Please suggest a solution.
Thank you. this was helpful. I am doing this at a file level (not item level) When a file is uploaded, I want the submitters permission on the file to change to readonly (so they cannot overwrite the file). I am using "Grant access to an item or a folder" and then using Recipients as "Created by Email". But it does not seem to honor it, even though the Flow runs successfully. Any thoughts?
Hello and thanks for your helpful videos. I have a question: Can you hide columns for some users? I mean, I have a group of 16 people working in a list with 10 columns and I want to show, for example, 6 columns to 3 users, all columns to one user, 3 columns to 2 users... Or any combination. The goal is each user or group of users focus in one section of the full process, for example, the guys in the IT warehouse need to focus only in the requirements of the other departments and at the same time, the manager can see and control the overall process just taking a look to all the columns. Can this approach be possible? Thanks again for your great content.
Nuno Guerra thanks Nuno for your message. I didn’t find any way to perform column permissions. One workaround is use multiple lists pointing to one main list and give permissions to those Sharepoint lists. That is the theory, I didn’t implemented yet but I think it can work. Next January I’ll in that project again so if I found something useful I will share it.
Hi, I have a scenario here where I would like to restrict the user access as following:
1. Member A create item X
2. ONLY member B/ C and D can view item X (and member A of course) and no on else (since I might have up to 50 members in the SharePoint site which I don't want them to see the details of item X). In this case Member B/ C and D are approvers of item X.
I know there is item-level permissions but it doesn't work for my scenario - you either have it all or nothing, e.g. everyone get to view all items or only those they created.
Great video. Is there a way to extract the recipient from another person column from the list? So the owner just updates the person column, and flow could pick up emails from there. Thanks.
Also one limitation is.. how about new members joining the SharePoint site? They will have full access/ view on all existing items right (in which I do not want to let them because of the sensitivity of the data)? Am I understand correctly? If yes, is there a quick solution?
Thank you for clarifying the issue with not being able to use SharePoint Group in the Recipients, this is what I was trying to figure out. This is really a huge downfall because most of these Lists I use for forms I want to make sure everyone in the members group still has rights to view after the approval flow is completed. There would be only a few select cases where I would want it limited to just the people involved in the approval process.
Not being able to use groups makes this unsable for most of my applications.
I wish I knew this existed earlier but easy to add on to my current projects. Thanks!
thanks for the video. The flow works fine as explained in the video. There is one problem however, that the grant access flow does not grant permission to any attachments that are in the list item. Please suggest a solution.
Great tutorial, thanks!
Thank you. this was helpful. I am doing this at a file level (not item level) When a file is uploaded, I want the submitters permission on the file to change to readonly (so they cannot overwrite the file). I am using "Grant access to an item or a folder" and then using Recipients as "Created by Email". But it does not seem to honor it, even though the Flow runs successfully. Any thoughts?
Hello and thanks for your helpful videos. I have a question: Can you hide columns for some users? I mean, I have a group of 16 people working in a list with 10 columns and I want to show, for example, 6 columns to 3 users, all columns to one user, 3 columns to 2 users... Or any combination. The goal is each user or group of users focus in one section of the full process, for example, the guys in the IT warehouse need to focus only in the requirements of the other departments and at the same time, the manager can see and control the overall process just taking a look to all the columns. Can this approach be possible? Thanks again for your great content.
Hi @dodecafono, do you have found any solution? I'm interested to know also how to hide columns for some users.
Nuno Guerra thanks Nuno for your message. I didn’t find any way to perform column permissions. One workaround is use multiple lists pointing to one main list and give permissions to those Sharepoint lists. That is the theory, I didn’t implemented yet but I think it can work. Next January I’ll in that project again so if I found something useful I will share it.
@@dodecafono thank you very much! I really appreciate.
You can hide columns with powerapps
Hi, thanks for good tutorial. I hope you will cover how to set record level permission in dataverse table based on person or group data in column
hopefully Yes! when PowerApps Series will begin.
Thank you. this was helpful.
Glad it helped you
Bhai nice tutorial but we can possibly break the full control permission inheritance. I hope you will cover those in your next chapter.
i think i have mentioned this already in video.
@@LernenTech Yes you did.👍
Hi, I have a scenario here where I would like to restrict the user access as following:
1. Member A create item X
2. ONLY member B/ C and D can view item X (and member A of course) and no on else (since I might have up to 50 members in the SharePoint site which I don't want them to see the details of item X). In this case Member B/ C and D are approvers of item X.
I know there is item-level permissions but it doesn't work for my scenario - you either have it all or nothing, e.g. everyone get to view all items or only those they created.
Appreciate your help!
Great video. Is there a way to extract the recipient from another person column from the list?
So the owner just updates the person column, and flow could pick up emails from there.
Thanks.
yes you can do that
appreciate, if you could guide me for that step.
@@jaspreetsingharora7070 drop me mail mention ur contact detail there
@LernenTech I will. Thanks a lot.
Hi, I would like to know if there's solution for this too.
How can we share file permissions based on SharePoint column value? If yes how.
Nice one..what about if we expect many files to be created i.e. more than 50k
it will run automatically.
Also one limitation is.. how about new members joining the SharePoint site? They will have full access/ view on all existing items right (in which I do not want to let them because of the sensitivity of the data)? Am I understand correctly? If yes, is there a quick solution?
How to get the list unique permissions in ms flows? Using Send http?
At Id i dont have any dynamic ID to select