Use TODAY () function in SharePoint list – Microsoft Community

Instead of relying on TODAY () in a calculated column, you can create a custom Date field (e.g., “Today’s Date”) and use Power Automate to automatically update this field to the current date every day. You can then use this “Today’s Date” field in your calculations to determine if an item is past, today, or upcoming.

https://answers.microsoft.com/en-us/msoffice/forum/all/use-today-function-in-sharepoint-list/f4d73e92-7a64-4410-80df-2a15eaa272a6