I added a 'Category' column to the 'Site Pages' list. I want the choices for this column to be populated by a list on the same site. I used a lookup column and it works well, but it cannot be used in a news web part. This is a problem because I want to show the news by category.
To solve this, I tried using Power Automate to update another column, but it does not trigger on create (since pages are created before assigning a category) and modified is not always triggered. Additionally, the 'modified' field is not always set to true on the 'Category' column, likely because it is behaving poorly due to the lookup function.
So, my question is, how can I populate the 'Category' column from another list in 'Site Pages' and make it usable in web parts for filtering?