Unanswered

Trigger a flow based on a document library date Column

(0) Share

Report

Posted on by Mamzy

Hi,

I have a document library that stores some documents and in the library i have two date fields, last reviewed date (this data is based on when the document is inputted into library and a next review date (this is a calculated column that takes the last reviewed date and adds a year on).

I want to create a flow that triggers and sends an email asking the owner to review the documents when todays date = next review date.

Iv had a look at some of the questions similar to this but non of them seem to work for me.

Please help.

Thanks in Advance

Categories:

Building flows

I have the same question (1)

All responses (2)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
I would have a Recurring trigger that runs daily and uses Get items with the following Filter Query. This is assuming the Last Reviewed Date is set to the date it was created initially, and updated each time it's reviewed.

//Assuming the internal name of your column is LastReviewedDate LastReviewedDate eq '@{addToTime(utcNow(), 1, 'Year', 'yyyy-MM-dd')}'

Alternatively, if you want to base it on the Calculated Column, you would need to return all items using Get items, then use a Filter array to filter. Get items doesn't allow you to use Calculated Columns in a Filter Query.

Was this reply helpful? Yes No
CB-13081930-0 2 on at

Like (0)

Report

Were you able to get this working? We are trying to do the same with our document libraries and I'm currently trying to find the process. The gentleman's answer deals with lists, but not libraries.

Was this reply helpful? Yes No