Blog Post
Use Azure Logic Apps to Notify of Pending AAD Application Client Secrets and Certificate Expirations
Thankyou Russ_Rimmerman for putting the Logic App version of this up! Really appreciate this much needed notification.
I got it working this morning but had to adjust a couple of settings - just sharing my experience;
1. I had to change the keyvault to use RBAC instead of the default vault access policy. My account had access using the vault access policy method, but it didn't work. Once I switched to RBAC and granted the 'Key Vault Secrets User' role, the logic app could read the keyvault entries.
2. The logic app kept failing because the 'To' field was empty in the email to app owners. This was because the app registration could not read the user account properties to get the email address. I had gone with Application.Read.All initially, so I added Directory.Read.All and this solved that issue.
Thanks