Forum Discussion
Expired to show if date or training has passed
Hi I'm creating a training tracker as a SharePoint list. Within the list I have a date column for when a course is going to require a refresher, which is a calculated column based of Date of Trai...
dbrown2275 you've got 2 options. 1) use JSON column formatting to change the Status column to display Expired although it won't change the underlying data, or 2) build a recurrence schedule flow in Power Automate that runs once a day to check the dates and update the Status column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Thanks Rob_Elliott
What would the recurrence flow look like for each scenario, Expiring and Expired?
Thanks
Darren