Skip to content
Skills Library
Programming · Automation

dataverse-flow-api

/dataverse-flow-api

Create, bind connections, activate, edit and debug Power Automate cloud flows through the Dataverse Web API from an authenticated browser session. Use for flows triggered by Microsoft Forms or HTTP that write Dataverse rows and notify by email and Teams.

Licence
MIT
Last repository change
27.10.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
1
Deprecation

No signals detected. Repository changed on 27.10.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

Create, bind connections, activate, edit and debug Power Automate cloud flows through the Dataverse Web API from an authenticated browser session. Use for flows triggered by Microsoft Forms or HTTP that write Dataverse rows and notify by email and Teams.

Original author description

Create, bind connections, activate, edit and debug Power Automate cloud flows through the Dataverse Web API from an authenticated browser session. Use for flows triggered by Microsoft Forms or HTTP that write Dataverse rows and notify by email and Teams.

How it works

  1. 1. Find the right environment first
  2. 2. Connection references
  3. 3. Create the flow
  4. 4. Activate, edit, deactivate
  5. 5. Forms trigger gotcha
  6. 6. HTTP-trigger flows (anonymous)
  7. 7. Debug a failed run
  8. Browser-tool notes
Original SKILL.md headings · 86 lines, 576 words
SKILL.md preview
---
name: dataverse-flow-api
description: Create, bind connections, activate, edit and debug Power Automate cloud flows through the Dataverse Web API from an authenticated browser session. Use for flows triggered by Microsoft Forms or HTTP that write Dataverse rows and notify by email and Teams.
---

# Power Automate flows through the Dataverse Web API

Run the calls from a browser tab already signed in to the Dataverse org
(`https://<ORG>.crm<N>.dynamics.com/api/data/v9.2/...`) using `fetch` in the page. Same-origin calls use the session.

## 1. Find the right environment first

Flows live in the environment that owns the Dataverse org. Do not guess environment IDs. Read them
from the portal URL or the org. A flow created in the wrong environment cannot see your tables.

## 2. Connection references

A flow created through the API uses connection references.

- List: `GET /connectionreferences?$select=connectionreferencelogicalname,connectorid,connectionid`
- Create (unbound): `POST /connectionreferences` with `connectionreferencelogicalname`,
  `connectionreferencedisplayname`, `connectorid = /providers/Microsoft.PowerApps/apis/shared_<connector>`.
- Bind: `PATCH /connectionreferences(<id>)` with `{ "connectionid": "<connection id>" }`.
  The connection id is the last-but-one segment of the connection details URL in the Power Automate
  portal: `.../connections/<connector>/<CONNECTION_ID>/details`.
- A flow cannot be turned on while any reference is unbound ("Connection Id missing for connection reference ...").

**Creating a Forms or Teams connection needs the user's OAuth consent.** Open
`Connections > New connection`, let the user finish the sign-in popup, and confirm the status is
`Connected` (not `Reconnect`) before binding.

## 3. Create the flow

`POST /workflows` with:

```json
{ "name": "<flow name>", "category": 5, "type": 1, "primaryentity": "none",
  "statecode": 0, "clientdata": "<JSON string>" }
```

`clientdata` = `{ "properties": { "connectionReferences": {...}, "definition": {...} }, "schemaVersion": "1.0.0.0" }`.
Each entry in `connectionReferences`:
`{ "runtimeSource": "embedded", "connection": { "connectionReferenceLogicalName": "<logical name>" }, "api": { "name": "shared_<connector>" } }`.

Actions use `type: "OpenApiConnection"` with `host: { connectionName, operationId, apiId }`,
`parameters`, and `authentication: "@parameters('$authentication')"`. See `templates/forms-to-dataverse-flow.js`.

Useful operation IDs: `CreateFormWebhook` (trigger), `GetFormResponseById`, `CreateRecord` (Dataverse),
`SendEmailV2` (Outlook), `PostCardToConversation` (Teams, poster "Flow bot", location "Chat with Flow bot").

## 4. Activate, edit, deactivate

- Activate: `PATCH /workflows(<id>)` `{ "statecode": 1, "statuscode": 2 }`
- To change the definition: set `statecode 0 / statuscode 1`, PATCH `clientdata`, activate again.
- Verify with `GET /workflows(<id>)?$select=statecode,statuscode`.
- The portal "edit" URL for an API-created flow may redirect to the flow list. Open the details page
  and use Edit there, or keep changing it through the API.

## 5. Forms trigger gotcha

A flow written by hand receives the trigger body as a batch:
`{ "value": [ { "eventType": "ResponseAdded", "resourceData": { "formId", "responseId" } } ] }`.
The path `triggerOutputs()?['body/resourceData/responseId']` is empty here. Use:

```
@first(triggerBody()?['value'])?['resourceData']?['responseId']
```

Form answers come back keyed by question id: `outputs('Get_response_details')?['body/r<32 hex>']`.
Multi-select answers arrive as a JSON-like string such as `["A","B"]`, so strip `[`, `]` and quotes.

## 6. HTTP-trigger flows (anonymous)

If the tenant allows it, `triggerAuthenticationType: "All"` makes an HTTP trigger callable without sign-in.
Return CORS headers from a Response action. The callback URL contains a signature, so treat it like a secret.

## 7. Debug a failed run

1. Portal: flow details, 28-day run history, open the failed run.
2. Click the red action and read **Inputs** and **Outputs**. A 400 with an empty parameter usually means a bad expression path.
3. Click the trigger to see the real trigger body and fix the path to match it.
4. Fix through the API, reactivate, and test with a real submission.

## Browser-tool notes

- Very large inline JavaScript can be rejected by the browser extension. Build the JSON inside the page from
  compact code instead of pasting a huge literal.
- A tab can vanish mid-task. Open a new tab and retry.
- Output containing URLs with signatures or query strings may be blocked. Do not print callback URLs.

Versions

The database has no other skills named dataverse-flow-api.

Database snapshot: 13.11.2026 · package version c7f96bb2a7ce (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100power-automate
    Use when operating Microsoft Power Automate cloud flows from code — create, enable, update, list or delete via the Dataverse Web API (`workflow` table, category 5) with Entra ID OAuth2, plus run-history debugging. NOT designing the flow definition (that is `automation-flows`),…
  • 100dynamics365-expert
    Expert in Dynamics 365 platform, model-driven apps, canvas apps, Power Automate flows, Dataverse, plugins, and custom workflows. Use when the user mentions Microsoft platforms, ERP, CRM, business apps, the Power Platform, or Dataverse, or when the task involves Dynamics 365…
  • 100power-platform
    Builds, ships and verifies Microsoft Power Platform work the way software is built: canvas apps as .pa.yaml in git, Dataverse tables, choices, roles and solutions, Power Automate cloud flows, pac pack and import, reporting from app history, and Power Pages sites (pages in git,…
  • 100power-automate-solution-flow-standards
    Standards for building Power Automate cloud flows that live in a Dataverse solution and are deployed through ALM - naming, connection references, trigger filtering, a reusable try/catch error-handling pattern, child flows, deployment settings and turning flows on after import.…
  • 96dataverse-python-api-reference
    dataverse-python-api-reference guidelines Triggers on: **
  • 100add-dataverse
    Adds Dataverse tables to a Power Apps code app with generated TypeScript models and services. Can also create new Dataverse tables. Use when connecting to Dataverse, adding tables, creating schema, or querying Dataverse data.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.