Making Microsoft Dataverse OAuth 2.0 queries using PAD

This example shows how to retrieve top 3 accounts from your Dataverse / Dynamics 365 environment using Power Automate Desktop.
Instructions

Follow these steps to generate and consume Dataverse OAuth2 v2.0 Endpoint Tokens for Dataverse using Power Automate Desktop (PAD).

  1. Register you application to get client_id and client_secret.
  2. Create an application user and add security roles.
  3. Set JSON values (see flow action line 2). Example:
⠀{
    "tenant_id": "57a86893-3de9-2641-ba9e-e7ad4a434512",
    "url": "https://yourcrminstance.crmX.dynamics.com",
    "client_id": "e2a16e96-83c1-41bf-9381-ef2c30518d4e",
    "client_secret": "_WX6T~lJHeDnk5KPisdIbY~2YqO2Oa1mlep1d"
⠀}
  1. Run flow. This will return top 3 accounts from your Dataverse environment.
Changes
  • 2022-01-01: Updated flow actions to work with Power Automate Desktop version 2.15.284.21354
PAG Admin