Flow to auto lock a sharepoint folder on a specified day of the week

(0) Share

Report

Posted on by CatPagulayan

184

Hello,

Not sure if this is an available feature already but would like to have a flow that locks a sharepoint folder (or a file in that sharepoint folder) for a specified date and time. The situation is that we do not want users to be able to edit or access the files every Friday and Saturday of the week.

Thanks in advance!

Categories:

General topics

All responses (6)

Answers (0)

Sort by

bradleyhorton 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CatPagulayan The 'stop sharing' and 'grant access' actions should be helpful here as long as the users you don't want accessing aren't Owners of the Document Library/Site.

You could run a recurring flow each day which check for day of the week then if Friday 'stop sharing', if Sunday 'Grant access'.
CatPagulayan 184 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bradleyhorton ,
thank you for the advise. But can you show me how to create a flow for that? Apologies as I am not familiar with what steps to choose in flow for the stop sharing and grant access.. thanks in advance!
bradleyhorton 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CatPagulayan

Please see image below. I've used switch rather than a condition and then in the stop sharing and grant access actions you just need to direct it at the relevant SharePoint site and Library. Id you add the ID of the top level folder you want to stop access to, then as long as everything below is inheriting permissions in SharePoint, I think the rest will just sort themselves out. I've only used these actions on specific files previously.
CatPagulayan 184 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @bradleyhorton ,
thank you so much for this!!
I tried but I ran into an error:
my flow is such: as in this simple..
bradleyhorton 187 on at

Like
a
(0)

Report
Copy link

Link copied!

@CatPagulayan annoyingly looks like it doesn't work with Folders then. As I said I've only used with specific files. Not sure if there's another way around this I'm afraid without getting each file in the folder and then using an Apply to each to loop through each one and change them all. Would guess that would take a while to run though.
bradleyhorton 187 on at

Like
a
(0)

Report
Copy link

Link copied!

@CatPagulayan this might help https://powerusers.microsoft.com/t5/General-Power-Automate/using-Flow-to-grant-access-in-SharePoint/td-p/332314