Sep 28 2020 07:56 AM
Hi!
I'm looking for a simple way to add a reviewdate column och the sitepages-site (/SitePages/Forms/AllPages.aspx) on a modern com-site .
We have a lot of information on different sitepages and need to review every two months. So if i create a new site it should get an atomatic review date today+2months. Any ideas?
Sep 28 2020 08:08 AM
@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.
Sep 28 2020 08:57 AM
@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
Sep 28 2020 09:02 AM
@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.
Nov 08 2021 04:37 AM
@ArefHalmstrand, you response to this enquiry looks like what I need too. However I have tried to work out what this might look like in PowerAutomate but struggling as new to using it.
Do you have example workflow I can follow? I am looking to set up a Power Automate to automatically send an email to the SharePoint page owner after a set time, for example each start of term.
With thanks
Jan 05 2022 03:18 PM
Feb 03 2022 01:03 AM
Feb 03 2022 01:55 PM