Share
ReportI 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):
All responses (
Answers (
2,837
