Reminder to review information on Sitepages in Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1720660%22%20slang%3D%22en-US%22%3EReminder%20to%20review%20information%20on%20Sitepages%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1720660%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20a%20simple%20way%20to%20add%20a%20reviewdate%20column%20och%20the%20sitepages-site%20(%2FSitePages%2FForms%2FAllPages.aspx)%20on%20a%20modern%20com-site%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20lot%20of%20information%20on%20different%20sitepages%20and%20need%20to%20review%20every%20two%20months.%20So%20if%20i%20create%20a%20new%20site%20it%20should%20get%20an%20atomatic%20review%20date%20%3CSTRONG%3Etoday%2B2months.%3C%2FSTRONG%3E%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1720660%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1720706%22%20slang%3D%22en-US%22%3ERe%3A%20Reminder%20to%20review%20information%20on%20Sitepages%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1720706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F631297%22%20target%3D%22_blank%22%3E%40AndreasBacklund%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EHello!%20You%20could%20easily%20solve%20this%20by%20adding%20a%20custom%20property%20field%20(date)%20with%20the%20name%20review%20date%20or%20similar.%20Then%20you%20can%20create%20a%20Power%20Automate%20that%20runs%20each%20day%20or%20week%20and%20looks%20over%20the%20pages.%20For%20each%20page%20it%20goes%20through%2C%20it%20can%20look%20at%20that%20specific%20date%20and%20see%20if%20two%20months%20has%20passed%20or%20not.%20If%20it%20has%2C%20it%20will%20send%20a%20notification%20to%20the%20page%20content%20owner%2C%20with%20an%20approval%20mail.%20If%20the%20content%20owner%20approves%20in%20the%20email%20response%2C%20then%20the%20Power%20Automate%20will%20update%20that%20specific%20page%20with%20a%20new%20value%20on%20the%20new%20column%20(review%20date)%2C%20to%20be%20todays%20date.%20That%20means%20the%20review%20have%20just%20been%20accepted%20and%20it%20will%20need%20to%20go%20another%20two%20months%20before%20the%20application%20picks%20it%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

3 Replies
Highlighted

@AndreasBacklund 

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.

Highlighted

@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

Highlighted

@AndreasBacklund 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.