cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Laura_St_Lukes
New Member

Notices to review current or old documents.

I would like to be able to assign a document a due date to be reviewed for accuracy after it has been published for a certain length of time. We have documents being stored for use by different departments in Sharepoint. They need to be reviewed for accuracy every 3 years. I see many notices for new items but nothing for reviewing old items.

2 REPLIES 2
masisley
Power Automate
Power Automate

Hi @Laura_St_Lukes,

 

You could potentially create a recurrence trigger that runs once per day or week that lists all documents in a sharepoint library (List folder), and then add an Apply to Each that checks for the LastModified value. If that time was 3 years ago, you could send an email or create an approval. The only problem here is that if a document is updated anytime in those three years, then this Flow won't notice the document. It's unfortunate that the SharePoint connector doesn't expose a Created timestamp...

 

Would that solve your problem?

 

Mark

 

Actually, it looks like you could also add a Date column to your Document Library in SharePoint. You could check whether today's date is greater than the due date column's value when you list folder. The only tricky thing then is making sure that the approval hasn't already been created. To solve this, you could add a second text column to indicate whether the Approval is already 'Pending' and only create an approval if it has no value. Then, you can update this column with Approval status (Pending, Approved, Rejected).

 

Have you tried Approvals in Flow? Details are here: https://flow.microsoft.com/en-us/blog/introducing-modern-approvals/

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,978)