All,
I'm fairly new to Sharepoint. We don't have a Sharepoint specialist at our company but we are using Sharepoint as a solution to create a simple certification tracking site. I have a list that contains records of certifications. Employees are certified in multiple areas. They are recertified yearly in each area to verify that they are competent in their work.
Here is an example of two records in my list.
You'll notice that in both records the Title and Employee field values are the same. You'll also notice that the Cert Issue Date field values are different.
I need a flow that will find records in a sharepoint list that have the same values in the Title and Employee fields but a different value in the Cert Issue date field. Then, once it has found those records I need the flow to update Active field for the most recent Cert Issue Date field to Yes and any others to No.
I need this flow because I need to be able to create a view to see when employees need to be recertified but I want only the most recent record. For example, if I have been trained on Sharepoint every year for the last three years, but I want to see when my next training is due, I only want to see the most recent record.
I hope this makes sense.
Thanks for the help.
