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.