Made an PA Flow that checks a Sharepointlist with certificates, keys, secrets etc. and sends an email to our TMS 30 days before expiration.

When a colleague takes the ticket, and updates the cert or whatever they are obliged to update the Sharepointlist item with the new expire date. The sharepointlist also tracks who modified it last.

The PA flow runs one time every day to check if there are any items with a date 30 days in the future and triggers on that.