Forum Discussion
Reminder to review information on Sitepages in Sharepoint
AndyBa
Hello! You could easily solve this by adding a custom property field (date) with the name review date or similar. Then you can create a Power Automate that runs each day or week and looks over the pages. For each page it goes through, it can look at that specific date and see if two months has passed or not. If it has, it will send a notification to the page content owner, with an approval mail. If the content owner approves in the email response, then the Power Automate will update that specific page with a new value on the new column (review date), to be todays date. That means the review have just been accepted and it will need to go another two months before the application picks it up.
ArefHalmstrand I created a column and could format it to take modified + 60. It sets the right date and i can use conditional formating for color. I searched for sharepoint-triggers or anything to connect in powerautomate. I want something like: If column is red -> send email
AndyBa I understand. 🙂
The column becomes red because of the conditional formatting. The same rule has to be applied in the validation for when the Power Automate goes through the pages. The trigger can be a button, frequency on each day/week/month etc and some more. So in short, if the "update" column date is past todays date, send email.