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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (3,157)