Unanswered

Creating a 'Page Review' reminder for SharePoint Site Pages

(1) Share

Report

Posted on by Paul_Bird

Hi community!

Is there a way of leveraging Power Automate to create a full process which manages SharePoint Site Page reviews? (As briefly discussed in Planning intranet governance - SharePoint in Microsoft 365 | Microsoft Learn under the 'Content review' heading.)

Process steps as we see them are:

Something which drives a constantly refreshing 'review date' value in the Site Page Library based on the creation date to begin with, and then subseqent review activities. Perhaps 6 months after either of those events.
Something which sends a reminder (email or 'Approval', or both) to a page owner defined in the Site Page Library, when the review date value is reached.
Something which then responds to the review activity to then move along the 'review date' value by another 6 months.
And all whilst ignoring News Posts in the Site Page Library, which I believe is done by looking for...
```
(PromotedState eq 0)
```

It's one of those processes which must be required by most large organisations, or really anyone with an Intranet like solution. And I'm surprised there isn't an 'out of the box' solution offered by Microsoft, like for Site Page Approvals.

Thanks so much for your support!

Categories:

Building flows

I have the same question (0)

All responses (21)

Answers (1)

Expiscornovus 33,181 Most Valuable Professional on at

Like (1)

Report

Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Hi @Paul_Bird,

Yes, it should be possible to setup something like that.

I would suggest to start adding that review date column to the site pages libraries. This way you can use that field in your scheduled review flows. In your flows you can compare todays date with that review date. Let us know if you need any additional help with the flow configuration.

Was this reply helpful? Yes No
Paul_Bird 54 on at

Like (0)

Report

Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Hi @Expiscornovus, thanks for the speedy response!
Makes sense, and just done...

Any thoughts on populating the 'ReviewDate' column? I could go with a calculated value, but that only works that one time, right? It doesn't work well for ongoing, continuous review activities.

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (1)

Report

Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Hi @Paul_Bird,

For ongoing review activities you could use that review date + number of days approach. After the review has been completed you can update the file properties and calculate/update the new review date within the flow. You could for example use an addDays function in an expression for this.

Was this reply helpful? Yes No
Paul_Bird 54 on at

Like (0)

Report
Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Thanks for the continued support. This makes sense I think!

If it helps with context and for anyone else doing this, I've put some more thought into the 'Review Date' column configuration within SharePoint and have carried out the following:
Made it require a value.
Set a default, calculated value to "=TODAY()+180".
And set column validation to "=AND([Review Date]>TODAY(),[Review Date]<TODAY()+181)" in the library settings formula view. (Which shows as "=AND(ReviewDate>TODAY(),ReviewDate<TODAY()+181)" in the list column editing view.)
I believe this a good place to start as it ensures the Intranet content review process has a value to work with, ensures it doesn't add an extra step for users creating a new Site Page as it automatically populates it from the start, and ensures that future values cannot be greater than 180 days from now.

So, now that we have a property to use against each item/Site Page within the Site Page library, would you be able to assist in setting up the start of the Flow? 🙏

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (1)

Report
Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Hi @Paul_Bird,

Below is an example Recurrence flow.

1. A Filter Query in a Get files (properties only) which checks if the ReviewDate value is less than or equal to (le) today (utcNow)

ReviewDate le '@{utcNow()}'

2. An expression which uses the ReviewDate value of the current item and adds 180 days via the AddDays function. That expression is used in the Update file properties action.

addDays(item()['ReviewDate'], 180)

Btw, I used this setup for the ReviewDate column

Was this reply helpful? Yes No
Paul_Bird 54 on at

Like (0)

Report

Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Superb! Thank you very much for getting me started on the flow 🙌

I've been playing around and this does indeed do the trick! (To allow me to test it, I temporarily ditched the column validation on 'Review Date' so that I could create some test pages with today's date. I'll add that back in once I know the flow is running perfectly.)

I've subsequently tried to swap this to an 'Approval' action within the flow so that we can put all of this activity through the great Approvals app in Teams. I've clearly done this wrong as it seems to now be waiting on each approval step to complete before it (the flow) moves on to the next page in the Site Pages library.

Here's what I've created...

You can see how the 'Start and wait for an approval' step along with the 'Switch' steps, are all nested within the 'Apply to each' step. Presumably this is where I'm going wrong, but I'm not sure how I can do this in alternative fashion?

Thanks for your help again!

Was this reply helpful? Yes No
Paul_Bird 54 on at

Like (0)

Report

Re: Creating a 'Page Review' reminder for SharePoint Site Pages

In case it's helpful - I ran the analysis capability and it provided this helpful process diagram of how it currently works...

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (0)

Report

Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Hi @Paul_Bird,

Yes, adding the start and wait for the approval makes the design totally different. My suggestion was for the notification/reminder stuff. Adding that waiting stepping will cause this behaviour.

In this scenario/with this requirement it might be better to have a parent flow which checks which files are due for review and trigger a child approval/reminder flow for the ones which are due.

Was this reply helpful? Yes No
Verified answer

Paul_Bird 54 on at

Like (0)

Report
Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Thanks for your advice on this @Expiscornovus!

After your very helpful foundations I spent quite a bit of time progressing the idea of an Approval focused approach, and now believe we have a pretty robust solution!

At the high-level, we are utilising the Site Pages library within the site, plus a new List which provides both a data store for the automation as well as a useful activity/audit log for the people interested in the process (the Internal Comms team in our instance). Then within Power Automate we have a 'Start' Flow, which is scheduled to run once a day, looking for pages within the Site Pages library which have a Review Date matching today's date. And 3 follow-up/completion Flows that look for the 3 possible responses to the Approval created by the 'Start' Flow, which update the page properties and audit List, and in one of those 3 Flows it also sends an email to the Internal Comms team to flag that a page is no longer required.

Here are some screenshots providing more detail for anyone interested...
--
The Site Pages library
--

The Review Date column settings
--

The List within the Site
--

The 'Start' content review process Flow (1 of 3)

The 'Start' content review process Flow (2 of 3)

The 'Start' content review process Flow (3 of 3)
--

An Approval response Flow "Changes made" (1 of 3)

An Approval response Flow "Change made" (2 of 3)

An Approval response Flow "Changes made" (3 of 3)
--

An Approval response Flow "No changes made" (1 of 3)

An Approval response Flow "No changes made" (2 of 3)

An Approval response Flow "No changes made" (3 of 3)
--

An Approval response Flow "Page no longer required" (1 of 4)

An Approval response Flow "Page no longer required" (2 of 4)

An Approval response Flow "Page no longer required" (3 of 4)

An Approval response Flow "Page no longer required" (4 of 4)
--

Some likely areas for improvement are:
Make the trigger for the Approval responses more unique, to ensure they aren't unecessarily triggered by other Approvals which are given the same custom responses in the future. (It won't break the process if this happened though, it would just fail to find a matching ApprovalID within the List.)
Tweak the wording in both the Approval and the email (for "page no longer required") and perhaps include more dynamic content to make them more useful.
Introduce a reminder Flow which looks at items in the List which have been "Pending" for longer than 7 days (or something like that), to help reduce the risk of Owners forgetting they need to do something.
Otherwise I think this is what we were after and I suspect numerous other organisations might benefit from this as well!

Was this reply helpful? Yes No
CraigVickery 2 on at

Like (0)

Report

Re: Creating a 'Page Review' reminder for SharePoint Site Pages

Hello @Paul_Bird, can you break out how you setup your columns for your audit page? (How did you define the Approval ID?)

Was this reply helpful? Yes No