Hello,
I am trying to get a flow to create a notification if an item is due today or was due previously, and then send this email to the document owner from a shared mailbox.
As in the screenshot below, I have the Last Review Date, then Review Frequency in days (some documents are 30 days, 90 days, 365 days, etc), and then a calculated column called Next Review Date that adds the data in Last Review Date + Review Frequency to make it work.
Basically, someone will upload a document to this library. They will then assign themselves or another person (or persons) as the Document Owner. The Last Review Date is automatically labelled as the date they uploaded it (ie today). The hope is that when it is 7 days before Next Review Date, an automated email will go out to the Document Owner to tell them that they need to take a look at the file and do what they want with it.
I've tried using the default "email reminder flow" but that doesn't seem to give me the option to change where the email comes from and who the email goes to - in addition whenever I try to point it to the Next Review Date column, the whole thing breaks even if I leave it pointed at me.
Any help would be appreciated. 🙂
