0

I have a Document Library (SP Online) in which users Upload documents, then they Modify the new File to add its properties. The user sets a Date column - "Published Date" manually after Uploading. I need a Reminder email to send 30 days after the Published Date. So my trigger should be when a File is Modified. My thought was to create a second Date Column (Email Date), and have Power Automate Update the File Properties. The problem is that I don't have the Syntax right, and it doesn't ONLY update the file properties of the recently Modified File. Rather, it updates every file in the Library. I'd like that Email Date column to basically equal the Published Date + 30 days, then I'd have it send an email on that Date. This should apply only the the Modified File, rather than all of them that exist in the Library. But I'm not setting this up correctly.

Any help would be greatly appreciated.

1 Answer 1

1

Here're steps:

1.Create a calculated column return data type as date and time, formula:=[Published Date]+30

2.Create a flow as following picture shows.

enter image description here

3
  • Thank you! So after creating that calculated column, my condition basically says "If Today = Email Date, Send an email"?
    – Chris
    Jan 6 at 14:18
  • 1
    Yes, if Today = Email Date, it will send an email. Jan 11 at 10:27
  • Thank you! Works perfectly
    – Chris
    Jan 12 at 13:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.