Hello!
Using flow,
EDIT: Many folder have unique permissions.
the idea is to
1. set a site for archive - this is where i need to change "edit" to "read" access for everyone who is part of a group which i achieved but not with shared links as i am not sure how to remove it.
2. wait 7 days and move document library to a archive location (achieved)
3. delete the site (acheived)
Will have it in mind, that's not a priority but defo will be done in couple of months!
Hello - I like your idea, but never used Power Automate. Could you please share the Power Automate script when ready and tested? Thanks
Hi, I am looking into the same challenge and what I am thinking of doing is using the usage report for SharePoint site (it is just under Site Usage and you request it and you receive email when it is done) and use it as a database of shared files and crawl through that. I have thousands of files to go through, but I might just mark on the spreadsheet (that's how the report is prepared) in one Power Automate step when the permissions will be revoked and use Do Until function with get items and and length function and Do Until the length of the batch is 0.
I will be preparing it so if you are interested I can save this page to share when it is ready.
question: this "get files" will get every single file whether it is shared or not and "stop sharing", i assume, will run whether the file has sharing link or not. get files has number of returned file count limitation. some of our project document libraries are huge that exceed 10k files and/or folders and goes beyond 150 gb as well.
Could you make some suggestions on how i can get all files without limit (which is impossible) so i can run this step just once OR get only the files and folders that has sharing links on it - which can be done through batches if I can use filters?
@v-bofeng-msft thanks! that's my plan b if i could not have a simpler solution to remove sharing permission to both folder and files at the same time - i was hopping for http request - in one step. with this get files and stop sharing solution, I need need 2 steps one for folder and the other for files.
Hi @rjack ,
You could use 'get files' list all files and use 'Stop sharing an item or a file' to stop sharing them.
Best Regards,
Bof
Best Regards,
Bof
Michael E. Gernaey
18
Super User 2025 Season 1
stampcoin
16
Churchy
12