below are refrence which i have used in video - /_api/lists/getByTitle('')/items()/breakroleinheritance(copyRoleAssignments=false,clearSubscopes=true) /_api/web/SiteUsers/getByEmail('') /_api/web/SiteGroups/getByName('') body('Get_Group_Detail')['d']['id'] /_api/web/lists/getbytitle('')/items()/roleassignments/addroleassignment(principalid=,roledefid=1073741826) Full Control - 1073741829 Design - 1073741828 Edit - 1073741830 Contribute - 1073741827 Read - 1073741826 View Only - 1073741924 Limited Access - 1073741825
Amazing vid! Straight to the point, no bullshit :D And after some tinkering, I quickly understood what the different values of copyRoleAssignments and clearSubscopes did, which was perfectly what I needed!
Thank you so much for this solution. I used this solution on 'Assigned To' column/filed, came across a problem. even if i change the assigned to person, it retains access to previously assigned people as well. Breaking item level permission is not breaking access to previously assigned people.
Hi Lernen Tech, I am struggling with writing the Uri for getting data of the SharePoint file access. I want to know who has access a list of files. Do you have any guide to share?
Hi Lernen Tech!, thank you for sharing knowledge. In my scenario each row of the list contains a field with a mail address. I want to let each mail user edit and see only the list items which he/she owns and don't let to see or edit anything else in the list. I suppose that "Apply to each" action then inside a "Grant access to an item or folder" action in order to retrieve the mail field as ID to assign the permissions dynamically, but not idea how to perform it. Please detailed idea or suggestion?, it would be much appreciated. Regards!
I think you can solve this by going to List Settings ==> Advanced Settings ==> Item-Level Permissions and select Create and Edit only items created by user
Users now only have "READ ONLY" access to a single line item - is there a way to get access back to each line item? Even when some users have full control access, they cannot change advanced permission settings to the item.
this is awesome! can you provide some details on the ['d']['id'] logic, everything works, but I would like to learn about this function. Any documentation that you point me to? Thanks!
At 15:30 he explains that the ['d']['Id'] values are contained in the JSON output from the HTTP GET actions. In order to extract just the principal ID value of a SharePoint Site Group or Site User to use as dynamic content in subsequent actions of the flow, you create a variable set to the ['d']['Id'] value of the GET output's Body.
Hello Lernen, Can you show me how to set item level permissions based on column value? i.e if I have column "Manager" which is person or group type. And when I choose the Manager on this column so only that mentioned person can see that list item.
If I have two groups and I create a second Get Group Detail and Group PrincipID Etc will the flow still work? The reason is that one group can edit and a second group needs to approve
Hi Sir, Is there a way.. that user gets added to sharepoint member group if he does not have access to sharepoint...I have created a flow it works for me as I am the owner of sharepoint but it doesn't work for others and throw authorization error
Hi sir this is what my requirements in my office. But slightly different mine. How could you contact you. For scenario explanation.. please help me and save me sir.. please
What permission does a regular user need to have on the site to call these API? This stuff really isn’t usable. There is no way a normal user would have full control on the site. We need the ability to call API with elevated permission in flow. And http is too expensive for a company or 1000 users
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
below are refrence which i have used in video -
/_api/lists/getByTitle('')/items()/breakroleinheritance(copyRoleAssignments=false,clearSubscopes=true)
/_api/web/SiteUsers/getByEmail('')
/_api/web/SiteGroups/getByName('')
body('Get_Group_Detail')['d']['id']
/_api/web/lists/getbytitle('')/items()/roleassignments/addroleassignment(principalid=,roledefid=1073741826)
Full Control - 1073741829
Design - 1073741828
Edit - 1073741830
Contribute - 1073741827
Read - 1073741826
View Only - 1073741924
Limited Access - 1073741825
Cannot express how thankful i'm, searched nearly one week till i found your video ! solved my problem - THANK YOU !!
glad it helped you :)
Amazing vid! Straight to the point, no bullshit :D
And after some tinkering, I quickly understood what the different values of copyRoleAssignments and clearSubscopes did, which was perfectly what I needed!
This has been very helpful! Thanks
Thank you so much for this solution. I used this solution on 'Assigned To' column/filed, came across a problem. even if i change the assigned to person, it retains access to previously assigned people as well. Breaking item level permission is not breaking access to previously assigned people.
thanks!
Thanks for the video
Got a question though - why not using " Grant access to an item or a folder" action?
Thank you so much for this!
Will this work for person/group column that allows multiple choices?
Sweet. I had to remove the /web/ bit after _api to make it work no idea what that does but works great now :)
Thank you very much you are the best!))
👍
Hi Lernen Tech, I am struggling with writing the Uri for getting data of the SharePoint file access. I want to know who has access a list of files. Do you have any guide to share?
Great 🙏👍😎
Please create video for site backup
Sure 👍
Hi Lernen Tech!, thank you for sharing knowledge. In my scenario each row of the list contains a field with a mail address. I want to let each mail user edit and see only the list items which he/she owns and don't let to see or edit anything else in the list. I suppose that "Apply to each" action then inside a "Grant access to an item or folder" action in order to retrieve the mail field as ID to assign the permissions dynamically, but not idea how to perform it. Please detailed idea or suggestion?, it would be much appreciated. Regards!
I think you can solve this by going to List Settings ==> Advanced Settings ==> Item-Level Permissions and select Create and Edit only items created by user
Users now only have "READ ONLY" access to a single line item - is there a way to get access back to each line item? Even when some users have full control access, they cannot change advanced permission settings to the item.
this is awesome! can you provide some details on the ['d']['id'] logic, everything works, but I would like to learn about this function. Any documentation that you point me to? Thanks!
At 15:30 he explains that the ['d']['Id'] values are contained in the JSON output from the HTTP GET actions. In order to extract just the principal ID value of a SharePoint Site Group or Site User to use as dynamic content in subsequent actions of the flow, you create a variable set to the ['d']['Id'] value of the GET output's Body.
hope you got your answer :)
Hi thanks for you video... how to breakroleinheritance in Document Library
Hello Lernen,
Can you show me how to set item level permissions based on column value? i.e if I have column "Manager" which is person or group type. And when I choose the Manager on this column so only that mentioned person can see that list item.
yes you can that as well, get you list item value and apply role directly
THANK YOU !!
👍
If I have two groups and I create a second Get Group Detail and Group PrincipID Etc will the flow still work? The reason is that one group can edit and a second group needs to approve
hope so
Is their any option to make user permission into read only for a particular column in a list
not sure for column
Hi, thanks a lot for this, is there a reason you didn't use "Stop sharing an item or a file" to break the permissions?
manual one you mean?
Because with "Stop sharing..." you cannot give access to sharepoint groups
Hi Sir, Is there a way.. that user gets added to sharepoint member group if he does not have access to sharepoint...I have created a flow it works for me as I am the owner of sharepoint but it doesn't work for others and throw authorization error
video is already on channel please check
Hi sir this is what my requirements in my office. But slightly different mine. How could you contact you. For scenario explanation.. please help me and save me sir.. please
@ please send me the Email ID sir
lernentech@gmail.com or whatsapp on +918766324942
Can you share the text from the text file? Thanks
please check pinned comment.
@@LernenTech What does pinned comment mean? I can't find the txt file that you use for your REST API.
Please disregard my previous comment.
What permission does a regular user need to have on the site to call these API?
This stuff really isn’t usable. There is no way a normal user would have full control on the site.
We need the ability to call API with elevated permission in flow.
And http is too expensive for a company or 1000 users
edit permission will work and this is for admin and developer those who are looking to create solution for their client.