Blog Post
Use Azure Logic Apps to Notify of Pending AAD Application Client Secrets and Certificate Expirations
Thanks for this Russ_Rimmerman really helpful!
FYI, I'm seeing an issue where after editing the logic app in designer, eg adding a new email address and adding email importance field, next logic app run is not returning accurate results.
In the inaccurate email, details in all fields are correct compared to successful run, except, for the ApplicationId and Displayname columns.
i.e. The number of apps listed in the inaccurate run are correct and they are in the same order as previous email but while the appid and displayname are aligned to one another, but they are random apps which are not in any way aligned to the other fields / are not apps that have expiring secrets/certs.
I can resolve the issue by deleting the logic app and connectors, editing the template json and re-importing.
I haven't got to root cause just yet and may not have time in next few days so wanted to call out now.
I haven't tested editing in code view yet and I am also wondering if I'm running subsequent runs too close together, ie graph connection still open or something cached.
Aengus