When integrating with Microsoft Dataverse, developers may need to interact with the Web API to perform advanced operations such as impersonating users, batching etc. While Power Automate provides the “Invoke an HTTP request” action to call Dataverse API, this approach has limitations, such as lack of reusability and maintainability. A better alternative is using a custom connector allowing secure and scalable Dataverse Web API interactions. This blog explores how to set up a custom connector that calls the Dataverse Web API as the signed in user.

Using the Dataverse Web API with a custom connector has advantages over the built-in Invoke an HTTP request connector, such as reusability and ensuring controlled access without exposing application user credentials, which is another way to call a Web API. Please see the picture below, which illustrates how to use the Web API with the connector

Use Cases of Dataverse Web API

The Dataverse Web API is powerful and enables many scenarios, such as:

• User Impersonation: Perform operations as another user (e.g. approvals, data updates).
• Batch Processing: Combine multiple operations in a single request to improve performance & to overcome API Request limits.
• Advanced Querying: Use OData queries for complex filtering and joins.
• Custom Business Logic: Extend functionality with plugin-like behavior through API calls.

Registering an App in Microsoft Entra ID (Azure AD) for Delegated Dataverse Web API Access

To access Dataverse Web API endpoints with a custom connector in Power Automate or Power Apps, there has to be Entra ID App registrations created for Delegated (Signed-In user) access.

Entra ID App registration for Signed In user (Delegated Access):

1. Navigate to Microsoft Entra ID.
2. Create a new App Registration and note the Application (Client) ID, Tenant ID & Client Secret.
3. Under API Permissions, click + Add a permission and search dataverse under APIs my organization uses as shown below

4. Click user_impersonation under Delegated permissions

5. Create a secret key under the Certificates & Secrets section and make a note of it. This key will be used when creating the custom connector

Creating the Custom Connector:

With the Entra ID app registered, the next step is to create the custom connector. This connector can be used in either a Power Automate flow or Power Apps to call the Dataverse Web API. To create the connector, go to Power Automate or Power Apps portal → Custom Connectors → New Custom Connector – Create from blank.

1. In the General Tab, Provide the Organization URL (Dataverse Environment URL) of your Dataverse environment under Host. It typically follows the format: orgxxxxxx.crm4.dynamics.com.

2. In the Security tab, set Authentication type:
   • Select OAuth 2.0
   • Enter the Client ID, Client Secret from the Entra Id app registration
   • Set the Resource URL to your Dataverse environment Url: https://orgxxxxx.crm4.dynamics.com/

3. Click Create connector. After this, the Redirect URL will be generated – Copy it. Next in the Entra ID App registration, navigate to the Authentication section under the Manage, add the copied Redirect URL by clicking + Add a platform and selecting Web, as shown below

4. Let’s add a simple Dataverse Web API endpoint /api/data/v9.2/WhoAmI, which provides information on the signed-in user’s Dataverse user ID. In the Definition tab, click + New action and provide an Operation id of your choice. Then click + Import from sample to enter the Verb as GET and the URL as /api/data/v9.2/WhoAmI and then click Import.

5. All set now – it’s time to test the connector. In the Test tab, create a new connection and then select the action (WhoAmI-Operation Id) to test. As shown below, it provides my signed-in Dataverse user ID for the Dataverse environment

Summary:

Using a custom connector provides a scalable and secure way to interact with Dataverse Web API. This approach improves maintainability compared to using Invoke an HTTP request directly. It also unlocks powerful capabilities like impersonation, batch processing etc. These are just a few examples of what can be achieved through the Dataverse Web API. If you are visiting my blog for the first time, please do look at my other blogposts.

Do you like this article?

Subscribe to my blog with your email address using the widget on the right side or on the bottom of this page to have new articles sent directly to your inbox the moment I publish them.

In Part 1 of this blog series, we explored how to set up Entra ID apps for both custom connectors (signed-in users) and daemon apps (sign-in on behalf of users). We also explored various Microsoft Graph API endpoints required to retrieve meeting transcription content.

In this post, we’ll explore how to retrieve transcription content using Microsoft Graph API endpoints. We’ll cover two approaches: a Custom Connector in Power Apps or Power Automate for signed-in users and an HTTP Connector in Power Automate to fetch data on behalf of a signed-in user.

Setting Up a Custom Connector:

The custom connector acts as a bridge between Power Apps or Power Automate and the Microsoft Graph API, enabling communication. I have already built the custom connector with all necessary actions to generate meeting transcripts using the Microsoft Graph API. You can download it from the link provided. After importing the solution into your environment, navigate to the Security tab in the custom connector and copy the Redirect URL.

Next, navigate to the Authentication section under the Manage blade of the Entra ID app registration and add the copied Redirect URL, as shown below

Configuring Authentication:

In the Security tab of the custom connector, enter the details from the Entra ID app registration, as configured in Part 1 of this blog series. Refer to the section Entra ID App registration for Signed In user (Delegated Access) – Custom Connector for retrieving these details:

• Make sure OAuth 2.0 is selected as the authentication type.
• Enter Entra ID (Azure AD) credentials:
  • Client ID
  • Client Secret
  • Tenant ID: common
  • Authorization URL: https://login.microsoftonline.com
  • Resource URL: https://graph.microsoft.com
  • Scope: OnlineMeetingTranscript.Read.All, User.Read, OnlineMeetings.Read, Calendars.Read
• Save and test authentication.

Defining the API Request:

1. Fetching User Events

To retrieve a user’s upcoming or past Teams meetings within a specified date range, use the following API request:

Endpoint:

GET https://graph.microsoft.com/v1.0/me/events?$select=id,subject,organizer,attendees,start,end,location,onlineMeeting&$orderby=start/dateTime desc&$top=3&$filter=start/dateTime ge '2025-02-03' and end/dateTime le '2025-03-07'

This request fetches the latest three events, including their ID, subject, organizer, attendees, start and end times, location, and online meeting details, filtered by a specific date range. This could changed based on your requirement

2. Retrieving a Meeting ID Using Join URL

If you have a meeting join URL from the above request and need to find its corresponding Meeting ID, use this API call:

Endpoint:

GET https://graph.microsoft.com/v1.0/me/onlineMeetings?$filter=JoinWebUrl eq {OnlineJoinURL}

This allows you to extract the unique identifier (meetingId) for a Teams meeting, which is required for fetching transcripts.

3. Retrieving Available Meeting Transcripts

Once you have the meetingId, you can list all available transcripts for that meeting using:

Endpoint:

GET https://graph.microsoft.com/v1.0/me/onlineMeetings/{meetingId}/transcripts

This response will include transcript details such as their unique transcriptId.

4. Fetching Meeting Transcript Content

To retrieve the actual transcript content in text/VTT (Web Video Text Tracks) format, use:

Endpoint:

GET https://graph.microsoft.com/v1.0/me/onlineMeetings/{meetingId}/transcripts/{transcriptId}/content?$format=text/vtt

This will return the full meeting transcript, which can be further processed for AI-driven summarization or note generation.

Testing the Custom Connector:

Authenticate and run a test request from the custom connector test interface after creating the connection. Verify that the transcription content is retrieved by testing all the different actions.

Using an HTTP Connector in Power Automate to get the Meeting transcriptions:

To obtain the transcription using Application permissions or on behalf of the user, use the details from the Entra ID app registration as configured in Part 1 of this blog series on the HTTP connector. This section covers from Part 1 Entra ID App registration for on-behalf-of signed-in users (Application Access) has the Client Id, Secret, Tenant Id for retrieving meeting transcriptions via the different Microsoft Graph API endpoints. Find below screenshot for getting the meeting transcriptions directly using the transcript URL

Enhancing Meeting Transcriptions with Azure OpenAI LLM

Azure Open AI models converts raw transcripts into structured, easy-to-read meeting notes, highlighting key discussion points, decisions, and action items. I have deployed gpt-4o-mini model in Azure OpenAI. API endpoint and Key for the model can be obtained from the Azure AI Foundary portal once after the model is deployed. Find the below the screenshot for calling the OpenAI LLM model using the HTTP Connector

You can also build a custom connector

Request Body:

{
  "model": "gpt-4o-mini",
  "messages": [
    {
      "role": "user",
      "content": "Create a short meeting summary and action items in bullet points from the following transcript:@{body('GETMeetingTranscript')}"
    }
  ]
}

Reference:

https://learn.microsoft.com/en-us/azure/ai-services/openai/how-to/create-resource?pivots=web-portal

Storing and Sharing the AI-Generated Notes

You can also save the AI-generated summary in for an end-end solution:

• SharePoint List.
• Dataverse

Workflow Summary

1. Retrieve transcription using Graph API (via Custom Connector or HTTP Connector).
2. Send transcription to Azure OpenAI for summarization.
3. Store or share the AI-generated meeting notes.

The Power Automate flow solution which uses the different custom connector actions to generate the meeting notes can be downloaded from

https://ashiqf.com/wp-content/uploads/2025/03/meetingnotesgenerationpowerautomateflow_1_0_0_1.zip

Meeting Notes generated from OpenAI model

Summary:

This solution utilizes a Power Automate flow with Graph API to retrieve Teams meeting transcripts and Azure AI LLM to generate meeting notes based on delegated and application permission. While this is a basic implementation, it can be expanded into a comprehensive solution by integrating with Power Apps for a user-friendly interface, enabling access to meeting summaries and insights with minimal investment. By combining Power Automate, Graph API, and Azure OpenAI organizations can automate meeting documentation, enhancing productivity.

Do you like this article?

Subscribe to my blog with your email address using the widget on the right side or on the bottom of this page to have new articles sent directly to your inbox the moment I publish them.

Microsoft 365 Copilot offers Teams meeting note generation, but its licensing costs can be a significant investment for organizations. For those looking for a more cost effective alternative, using Power Automate or Power Apps with Microsoft Graph API and Azure OpenAI provides a scalable and budget friendly solution.

In this series, we will explore how to automate the process of generating meeting notes by leveraging the Microsoft Graph API to retrieve meeting transcriptions and summarizing them using Azure OpenAI’s language models. We will cover both delegated permissions (retrieving transcriptions as the signed-in user) and application permissions (retrieving transcriptions on behalf of a user).

In Part 1, we will explore the Microsoft Graph API endpoints required to access Teams meeting transcriptions and the setup of Entra ID app registrations. In Part 2, we will look at how to integrate these APIs into Power Automate using a Custom Connector (for signed-in users) and the HTTP Connector (for application-level access) to fetch meeting transcriptions

Retrieving Meeting Transcriptions with Microsoft Graph API

To start, we need to extract meeting transcriptions from Microsoft Teams using Microsoft Graph API. Microsoft provides endpoints for accessing recorded meeting transcriptions, but there are specific permissions and configurations required.

Prerequisites

Before proceeding, ensure that you have:

• Access to Register app registration in Entra ID Portal
• Power Automate / Power Apps premium license. To test the custom connector you can also get a community plan if you do not have a premium plan.
• An Azure OpenAI service instance for text processing.

Step 1: Set Up Permissions in Azure AD

To access Microsoft Graph API endpoints with a custom connector and HTTP connector in Power Automate, there has to be Entra ID App registrations created for Delegated and Application access.

Entra ID App registration for Signed In user (Delegated Access) – Custom Connector:

1. Navigate to Microsoft Entra ID.
2. Create a new App Registration and note the Application (Client) ID, Tenant ID & Client Secret.
3. Under API Permissions, add the following Delegated permissions:
   • OnlineMeetings.Read
   • OnlineMeetingTranscript.Read.All
   • Calendars.Read
   • User.Read

4. Grant admin consent to apply the permissions.

Entra ID App registration for on behalf of Signed In user (Application Access) – HTTP Connector:

1. Navigate to Microsoft Entra ID.
2. Create a new App Registration and note the Application (Client) ID, Tenant ID & Client Secret.
3. Under API Permissions, add the following Application permissions:
   • OnlineMeetings.Read.All
   • OnlineMeetingTranscript.Read.All
   • Calendars.Read
   • User.Read.All

Allow applications to access online meetings on behalf of a user:

To access Graph API endpoints for retrieving meeting transcriptions on behalf of the signed-in user, an Application Access Policy must be configured for the Entra ID app registration created earlier using the Client ID. Execute the Power Shell script as below

New-CsApplicationAccessPolicy -Identity AAP-policy -AppIds "ReplaceClientIdfromEntraIDAppRegforApplicationAccess" -Description "To grant the Application access to MS Graph API Endpoints for Transcription"
Grant-CsApplicationAccessPolicy -PolicyName AAP-policy -Global

There is also a Power Shell command which can be used to provide access to the application for a specific user.

Reference: Configure application access policy

Note: If the app registration is not granted access through the application access policy, attempting to access the Graph API endpoint for transcription content will result in the following error.

Application is not allowed to perform operations on the user ‘xxxx-xxxxx-xxx-xxx-xxxx’, neither is allowed access through RSC permission evaluation.

Step 2: Retrieve Transcriptions with Microsoft Graph API

Microsoft Graph API provides endpoints for accessing and managing Teams calendar events and transcripts. We’ll explore how to retrieve user events, extract meeting IDs, and obtain transcript content URLs.

1. Retrieving User Events

To fetch a list of calendar events for a user:

GET https://graph.microsoft.com/v1.0/me/calendar/events

This request returns details about the user’s scheduled events, including subject, start and end times, location, and attendees.

Reference: Microsoft Graph API – Get User Events

2. Retrieving a Meeting ID

To retrieve a meeting ID using the join URL:

GET https://graph.microsoft.com/v1.0/me/onlineMeetings?$filter=JoinWebUrl eq ‘joinURL’

This request filters online meetings based on the provided join URL obtained from the previous API endpoint call and returns the meeting ID.

Reference: Microsoft Graph API – Get Online Meeting

https://learn.microsoft.com/en-us/microsoftteams/platform/graph-api/meeting-transcripts/fetch-id

Snapshot from Graph Explorer

Retrieving Transcript Content URL

To access the transcript content URL for a specific meeting that has been recorded or is configured to generate transcriptions:

GET https://graph.microsoft.com/v1.0/me/onlineMeetings/{online-meeting-id}/transcripts

This request fetches the transcripts associated with a Teams meeting

References:

• Microsoft Graph API – List Transcripts
• Microsoft Graph API – Get Call Transcript

Note: There are change notification which could be configured to get notified whenever a transcript is available after a meeting.

https://learn.microsoft.com/en-us/graph/teams-changenotifications-callrecording-and-calltranscript

Next Steps

In Part 2, we will create custom connector / HTTP connector and use them in Power Automate with Azure OpenAI’s GPT model to summarize the transcription and generate structured meeting notes. Stay tuned!

Do you like this article?

Subscribe to my blog with your email address using the widget on the right side or on the bottom of this page to have new articles sent directly to your inbox the moment I publish them.