Any way to (re)set column views in SharePoint?

(3) Share

Report

Posted on by anthonys123

483

I don't know how or why but our Sharepoint views are constantly changing. I have a specific template I want to apply for several views across the sites in our tenant.

Is there any way to reset these on a schedule using Power Automate?

Esentially, for example, we have tenant/sites/division/projects and views for Sort by: Name, Sort by: Address, Sort by: Modified and Status: Active, Status: Service, Status: Archive. The Sort views are sorting based on those column names. The Status views are filtering for the values in the Status column. There's actually about 10-12 views per site and currently 9 sites.

I'm not aware of any actions in PA to accomplish this but I am desperate to fix this issue. I've already removed permissions or anyone to change the views so I don't know what could be changing dozens of them.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Power Platform 1919 2,254 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @anthonys123,
Can you check this article :Create SharePoint List View Using REST API in Power Automate

may be this can help !!!.
It uses Share Point Rest Api and Power Automate combo!!!

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @anthonys123,

Power Automate doesn’t have a built-in “reset views” action, but we can lock this down in two supported ways:

Site scripts/site templates (recommended): define your canonical views once with addSPView (columns + CAML sort/filter) and optionally remove unwanted ones with removeSPView. Reapplying the script to any site reliably resets views to your baseline. See: https://learn.microsoft.com/sharepoint/dev/declarative-customization/site-design-json-schema#create-a-new-sharepoint-list and https://learn.microsoft.com/sharepoint/dev/declarative-customization/site-design-overview#anatomy-of-a-site-script

Scheduled Power Automate flow: use “Send an HTTP request to SharePoint” to call the REST API for each list/view and update the view’s CAML (sort/filter/columns) on a schedule (e.g., nightly). This enforces your Sort by Name/Address/Modified and Status = Active/Service/Archive views across sites. See: https://learn.microsoft.com/sharepoint/dev/business-apps/power-automate/guidance/working-with-send-sp-http-request

Was this reply helpful? Yes No