Approval Flow - IS THIS POSSIBLE

(0) Share

Report

Posted on by Robin_White5133

Prior to spending hours attempting to create the flow, is this at all possible:

I want to create a flow that will do the following:

On a date specified in a 'Date' column named 'Review Due Date' within a document library, 14 days before the 'Review Due Date', the document is put to 'pending', an email sent to an individual requesting them to review and approve based on a 'Person' column, and then update the Review Date Column to a year after the review took place.

Is this at all possible or am I trying to do the impossible. Please bear in mind I am a novice in Power Automate.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!
Yes, you can do that with a Scheduled type flow. It would be something like this.

Trigger - Schedule Daily

Get Items - filter ReviewDueDate eq addDays(utcNow(),-14)

Update Item - to Pending

Start and Wait for Approval - send email approval to person column

(After the Approval is completed)

Update Item - ReviewDueDate column with addDays(utcNow(),365)

This is a skeleton outline (and the Get Items filter might need to be tweaked), but this is the basic structure of what needs to happen.

Was this reply helpful? Yes No
Robin_White5133 34 on at

Like (0)

Report
Copy link

Link copied!

Many thanks for the information, I will give it a go and let you know how I get on. 😀

Was this reply helpful? Yes No