How to Combine Dataverse, Azure Blob Storage, and Outlook in One Automation Flow

Badges Claimed: Stairway to heaven

One flow. Three Microsoft Cloud APIs and perfectly combined to create real impact.

How could we build this for our EcoCraft scenario that actually makes sense? The answer:
A fully automated flow that connects session completion, certificate creation, storage, and communication without manual steps, without friction. That saves a lot of time for the NGO worker. They don’t have to worry about any of these.

When a student completes a session, several things should happen automatically:

  • The system should know the session is done
  • The correct registration data should be used
  • A certificate should be created and stored securely
  • Teachers should be informed that their students succeeded

All of this happens in one single Power Automate flow, powered by three Microsoft Cloud APIs working together.

The flow starts in Dataverse and is triggered when a session is marked as completed. It fetches relevant data from the event registration and uses that data to trigger a journey in Customer Insights – Journeys.

Once the certificate is created (via DCP), it needs a home. The Azure Blob Storage API stores the generated certificate. The files are centrally available, secure, and scalable.

We are closing the loop with communication via the email. That’s where the Outlook API comes in. It automatically sends an email to the teacher and confirms that their students have successfully claimed their certificates. This keeps teachers informed without manual follow-ups.

This flow is a great example of how Microsoft Cloud services shine when they’re combined, not isolated.