
Announcements
I have a Power APP built on a SharePoint list. I am trying to track training on each platform that requires training. Training on each platform is only valid for 1 year. If we have failed to complete the annual refresher training within a year, then we have to do the initial training instead of the annual. I already have power automate sending out an email with the recorded dates of training but I think it will be difficult to find the expired dates once the table is populated with all the dates for each employee and platform.
All dates are stored in date columns in the SharePoint list.
I am open for ideas but I think I just need to clear the cell contents once the training date is over 1 year old. What is the best way to accomplish this? Or should I go a different direction?
Example of output email data(power automate):
I would do it like this:
- Create a flow that runs daily at e.g. 4am
- Get all records where training date is older than 1 year.
Get items odata Filter Query example: