Forum Discussion
Solved
Grant group access to multiple list items at once
Hi
I am looking at creating Groups in order to manage access to specific records in a SharePoint List, people will only be allowed to see the records for the countries that they are in charge of.
I know that I can click every record individually and Manage Access that way, adding the appropriate Group to the record but the list has around 500 records and doing each record manually seems like a massive waste of time.
I can filter (or use Group By) the list based on a Country field but is there a way to then bulk Manage Access for all of these records at the same time? I am not against using PowerShell if necessary but it seems like there should be some sort of built in functionality that I am missing.
Thanks
GFinlayTerumo If you have to make use of unique rights, they should be set at the highest possible level if you are going to be able to maintain them. The simplest solution, I think, is therefore that you divide your current list into several lists (for example, one list per country) and instead administer the rights at the list level instead of at the element level.
GFinlayTerumo If you have to make use of unique rights, they should be set at the highest possible level if you are going to be able to maintain them. The simplest solution, I think, is therefore that you divide your current list into several lists (for example, one list per country) and instead administer the rights at the list level instead of at the element level.
- Thanks for your response. That was one of our first considerations but the list in question is linked to several Power Automate flows and PowerBi Dashboards/Reports so creating new lists would mean a lot of further work on the dependencies which we were trying to avoid. Running both the individual country lists and treating the existing one as a Master list might be our best way forward if there is no elegant solution for bulk access for each element.
Thanks
