Unanswered

Updating Columns Automatically in Sharepoint

(0) Share

Report

Posted on by IJustGotHere

I am entirely new to SharePoint and I have spend a few days looking for a solution to my problem.

Essentially, what I want to do is build a flow so that "When a file is created or modified (properties only)" the flow first checks whether the value of the choice column of the page that was just created or modified is equal to "Hero News". If it is, I want it to check whether there are already 5 pages with the value "Hero News". If there are, I want it to take the oldest page out of the 5 and change its choice column value to "General News".

I think I have figured out how to make this work if firstly, I find a way for the flow to identify the name of the file that triggered the flow in the first place, and secondly find a way for the flow to then only identify the name or ID of the oldest page with the choice column value of "hero news".

I hope someone can help me out, that would really make my week.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

RobElliott 10,391 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@IJustGotHere it seems to me you don't need a flow for this: create a column in your Site Pages library which is a Yes/No column called HeroNews. Add a news web part to your page, edit it and select Filter, select Page Properties then HeroNews equals Yes. When you create a new news story, if it's a HeroNews item select that from the page properties.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No
IJustGotHere 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @RobElliott thank very much for your reply. However, unless my understanding of the solution that you provided is lacking, I am afraid the solution you suggest will not solve my issue.

To explain why, I will provide additional context: our SharePoint's home page features a news web part with the tiles layout, underneath of which there is a highlighted content web part with the filmstrip layout. This is our preferred layout to display our news. We have set it up so that the news in the news web part only displays pages with the managed property "Page Category" value of "Hero News" and the highlighted content web part only displays pages with the value of "General News". Because the news web-part is only showing 4 pieces of news at a time, we want to automatically have the oldest news' Page Category value change to "General News" from "Hero News" when new news is created with the value of "Hero News". Thus, effectively pushing news that would no longer be displayed in the "Hero News" section to the "General News" section.

Hence, the solution that I came up with (and this may be overly complicated due to my lack of knowledge) is a power automate flow that, whenever a new page is created with the "Page Category" column value of "Hero News", checks whether there are 5 pages with the value "Hero News" and if there are, have it update the oldest page to "General News".

My apologies for the long message, I appreciate your help and time and I hope you can support me in finding a solution.

Kind regards,

Sem

Was this reply helpful? Yes No