Notify Application’s Certificates & secrets – Power Automate
Notify in teams/outlook about Application’s Certificates & secrets using Power Automate.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-14.png?resize=640%2C571&ssl=1)
- Initialized variable of array type to store application data.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-15.png?resize=640%2C202&ssl=1)
- Add list applications and owners action from Azure AD app registration connector.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-16.png?resize=640%2C358&ssl=1)
- Loop each value listed down from the list applications and owner action. Here the value is referred from dynamic content.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-4.png?resize=640%2C397&ssl=1)
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-5-1024x485.png?resize=640%2C303&ssl=1)
- Now add nested for loop to iterate each client secrets available under each applications, where passwordCredential will return all the client secret details in an array structure.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-6.png?resize=640%2C527&ssl=1)
- I’ve added condition to get the client secrets which is already expired. Here endDate is referred from previous passwordCredential loop.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-7.png?resize=640%2C224&ssl=1)
- Inside true condition we are appending the client secret value(Display Name, End Date, App Name and Type) into the AppData(array variable).
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-8-1024x649.png?resize=640%2C406&ssl=1)
- Follow the same step to loop certificate details. Replace passwordCredential reference with keyCredentials to loop the certificates.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-9.png?resize=640%2C600&ssl=1)
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-10-1024x582.png?resize=640%2C364&ssl=1)
- Now, we have the all the expired data in AppData variable. Using this we are going to construct HTML table.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-11.png?resize=636%2C219&ssl=1)
- Then add teams/outlook action to notify the users. And include the HTML reference in the message body.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-12.png?resize=640%2C383&ssl=1)
- Finally, you will get notified with teams/outlook message.
![](https://i0.wp.com/365stack.in/wp-content/uploads/2023/11/image-13.png?resize=489%2C151&ssl=1)
Happy Building… 🙂
0
Tags :