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.
