Expired to show if date or training has passed

Question

Hi&nbsp;I'm creating a training tracker as a SharePoint list. Within the list&nbsp;I have a date column for when a course is going to require a refresher, which is a calculated column based of Date of Training + Refresher period.If I set up a choice column with the following options - In Date, Expiring and Expired, how can I achieve the following:When a refresher date is 30 days away the status changes to 'Expiring'When a refresher date has passed the status changes to 'Expired'&nbsp;ThanksDarren

rob_elliott · Answer

dbrown2275&nbsp;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.&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User.Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

dbrown2275 · Answer

Thanks&nbsp;Rob_Elliott&nbsp;What would the recurrence flow look like for each scenario, Expiring and Expired?ThanksDarren

Forum Discussion

Expired to show if date or training has passed

2 Replies