Forum Discussion
How to get a list of all users and their permission level per item
Is there a way to get a list of all the users and permission levels per library, dynamically, without manually checking each item?
Instead of going through Manage Access, I'd like to create a report (Excel) to list all the items, then per item list all the users and their permission levels.
Library > Folder Name1 > File Name1 >
> User1 - Edit
> User2 - Read
> Group1 - Edit
Library > Folder Name2 > File Name2 >
> User1 - Edit
> User2 - Read
I'm reading this article and it seems to only cover how to grant and stop sharing
https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/manage-list-item-file-permissions
2 Replies
- This free and open source app might help you: https://github.com/Barbarur/NovaPoint
The app can generate a permissions report as per docs: https://github.com/Barbarur/NovaPoint/wiki/Solution-Report-PermissionsReport - You can script it out using Powershell, that's the easiest and fastest way to do it!.
