Automated Azure AD Credential Expiration Alerts

All secrets and certificates created within Azure App Registrations have expiration dates, making it crucial for administrators to stay informed to take timely action. Microsoft does not provide an automated notification for this. However, by leveraging Microsoft Graph API and Power Automate, you can set up automated alerts to notify when secrets and certificates are nearing expiration—or have already expired. Below is an example e-mail of expiring and expired secrets and certificates generated by Power Automate: The end-result in e-mail showing expiring secrets, expired secrets, as well as an a csv export of all secrets. Requirements You'll need…

Comments Off on Automated Azure AD Credential Expiration Alerts

Cancel an Approval of Behalf of Another User in Power Automate

Using the Approvals Connector within Power Automate is a great way to streamline approvals, as it provides a lot of functionality out of the box. One limitation it has however is the ability to cancel an approval on behalf of another user. For that, we need to use Power Automate and make an update directly in the Approvers table record. Example - Purchase Order Approval Request Using a Model Driven App, I have an IT Inventory tracking system where I need to submit Purchase Orders for manager approval. When the flow button is pressed in the app, the…

Comments Off on Cancel an Approval of Behalf of Another User in Power Automate

Fast and Efficient Pagination in Power Automate

Pagination is frequently used by APIs to divide large sets of data into manageable "pages." In this post, I’ll show you how to efficiently paginate and collect all the results into an array in Power Automate—without using Apply to Each. I’ll also include a quick performance comparison so you can see the impact for yourself. The difference in speed will surprise you! Use Case: The Office 365 Users Connector I want to use an example where you can try this against your own tenant: the Office 365 Users connector. One of it's actions is the Send an HTTP…

Comments Off on Fast and Efficient Pagination in Power Automate