Create a Dataverse Table With Every Common Column Type Using Power Automate
If you have ever clicked through the maker portal to build a Dataverse table column by column, you know how slow it gets. There is a faster, repeatable way: send one HTTP request to the Dataverse Web API and let it build the whole table — primary column, choices, currency, dates, the lot — in a single shot.
In this post I will walk through a Power Automate cloud flow that does exactly that. It creates a demo table called Sample Product with one column of every common type, so you can see how each column type is defined in the Web API.
The idea in one line
Dataverse exposes a metadata endpoint. POST a JSON definition of your table to it, and Dataverse creates the table and all the columns you described.
POST https://yourorg.crm.dynamics.com/api/data/v9.2/EntityDefinitions
Replace yourorg with your own environment URL. You can find it in the Power Platform Admin Center under your environment's settings, or in the address bar when you open any model-driven app.
The flow at a glance
The flow has just two steps after the trigger:
| Step | Action | What it does |
|---|---|---|
| Trigger | Manually trigger a flow | Lets you run it on demand with a button |
| 1 | Compose | Holds the full table definition as JSON |
| 2 | HTTP request | POSTs that JSON to the EntityDefinitions endpoint |
Keeping the definition in a Compose action makes the flow easy to read and easy to tweak. The HTTP action just points at the Compose output.
Connector note: This example uses the HTTP with Microsoft Entra ID (preauthorized) connector (the "Invoke an HTTP request" action). It is a premium connector, but it handles authentication to Dataverse for you, so you do not have to manage tokens by hand.
Step 1 — Compose the table definition
The Compose action holds an EntityMetadata object. The top part describes the table itself; the Attributes array describes each column.
Here is the table-level part:
{
"@@odata.type": "Microsoft.Dynamics.CRM.EntityMetadata",
"SchemaName": "new_SampleProduct",
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{ "@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel", "Label": "Sample Product", "LanguageCode": 1033 }
]
},
"DisplayCollectionName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{ "@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel", "Label": "Sample Products", "LanguageCode": 1033 }
]
},
"OwnershipType": "UserOwned",
"IsActivity": false,
"HasActivities": false,
"HasNotes": false,
"Attributes": [ ... ]
}
A few things worth knowing here:
| Property | Meaning |
|---|---|
SchemaName |
The internal name. new_ is the default publisher prefix — change it to match your own solution publisher. |
DisplayName |
The singular label shown in the UI ("Sample Product"). |
DisplayCollectionName |
The plural label ("Sample Products"). |
OwnershipType |
UserOwned means rows belong to a user or team. Use OrganizationOwned for shared reference data. |
LanguageCode: 1033 |
The locale ID for English (United States). Use your own LCID if needed. |
Why the double @@?
You will notice @@odata.type instead of @odata.type. This is a Power Automate quirk, not a Dataverse one. In Power Automate the @ symbol starts an expression, so to send a literal @ you have to double it. When the flow runs, @@odata.type is sent to Dataverse as @odata.type. If you copy this JSON somewhere outside Power Automate, drop one of the @ signs.
The column types, explained
Every column lives in the Attributes array and needs a matching @odata.type. Pick the wrong type and you get a 400 Bad Request. Here is each column type used in the demo table:
| Column | @odata.type |
Dataverse type | Notes |
|---|---|---|---|
| Product Name | StringAttributeMetadata |
Single line of text | The primary name column. IsPrimaryName: true, MaxLength: 100. Every table needs exactly one. |
| Description | MemoAttributeMetadata |
Multiple lines of text | Format: TextArea, MaxLength: 2000. |
| Quantity | IntegerAttributeMetadata |
Whole number | Set MinValue / MaxValue to bound it. |
| Serial Number | BigIntAttributeMetadata |
Big integer | For very large whole numbers. |
| Weight | DecimalAttributeMetadata |
Decimal number | Has Precision (decimal places) and min/max. |
| Rating | DoubleAttributeMetadata |
Float | Floating-point number; also has Precision. |
| Price | MoneyAttributeMetadata |
Currency | Uses PrecisionSource (0 = no decimals, 1 = currency precision, 2 = pricing decimal precision). |
| Is Active | BooleanAttributeMetadata |
Yes/No | Needs an OptionSet with a TrueOption and FalseOption. |
| Received Date | DateTimeAttributeMetadata |
Date and time | Use Format: DateAndTime, or DateOnly for a date-only column. |
| Category | PicklistAttributeMetadata |
Choice (single) | A local choice set. Option values start at 100000000. |
| Tags | MultiSelectPicklistAttributeMetadata |
Choices (multi) | Note its AttributeType is Virtual, not MultiSelectPicklist. |
The primary name column (the one you cannot skip)
{
"@@odata.type": "Microsoft.Dynamics.CRM.StringAttributeMetadata",
"AttributeType": "String",
"AttributeTypeName": { "Value": "StringType" },
"SchemaName": "new_ProductName",
"IsPrimaryName": true,
"MaxLength": 100,
"FormatName": { "Value": "Text" },
"RequiredLevel": { "Value": "None", "CanBeChanged": true, "ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings" },
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{ "@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel", "Label": "Product Name", "LanguageCode": 1033 }
]
}
}
If you forget IsPrimaryName: true, or include zero (or more than one) of them, the request fails. This is the most common mistake when building tables this way.
A choice column (single select)
A local choice set lives right inside the column definition. Each option needs a numeric Value and a label:
{
"@@odata.type": "Microsoft.Dynamics.CRM.PicklistAttributeMetadata",
"AttributeType": "Picklist",
"AttributeTypeName": { "Value": "PicklistType" },
"SchemaName": "new_Category",
"OptionSet": {
"@@odata.type": "Microsoft.Dynamics.CRM.OptionSetMetadata",
"IsGlobal": false,
"OptionSetType": "Picklist",
"Options": [
{ "Value": 100000000, "Label": { "@@odata.type": "Microsoft.Dynamics.CRM.Label", "LocalizedLabels": [ { "@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel", "Label": "Electronics", "LanguageCode": 1033 } ] } },
{ "Value": 100000001, "Label": { "@@odata.type": "Microsoft.Dynamics.CRM.Label", "LocalizedLabels": [ { "@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel", "Label": "Apparel", "LanguageCode": 1033 } ] } }
]
}
}
Set IsGlobal: true if you want a global choice set that other tables can reuse. The multi-select column ("Tags") follows the same shape — the only real difference is the @odata.type and that its AttributeType is reported as Virtual.
Step 2 — The HTTP request
The second action posts the Compose output to Dataverse:
| Setting | Value |
|---|---|
| Method | POST |
| URL | https://yourorg.crm.dynamics.com/api/data/v9.2/EntityDefinitions |
| Body | @outputs('Compose_Table_Definition') |
And the headers:
Content-Type: application/json; charset=utf-8
OData-MaxVersion: 4.0
OData-Version: 4.0
Accept: application/json
On success Dataverse returns HTTP 204 No Content, with an OData-EntityId header pointing at your new table. No body comes back — the empty 204 is the success signal.
Two improvements worth adding
The base flow works, but two small additions make it production-friendly.
1. Put the table in a solution. As written, the new table lands in the Default Solution, which is an ALM anti-pattern — it makes the table hard to move between environments. Add this header to the HTTP action so the table is created inside your own unmanaged solution:
MSCRM.SolutionUniqueName: YourSolutionUniqueName
Use the solution's unique name, not its display name.
2. Read it back with a strong-consistency header. Metadata is cached, so if you immediately query the new table it might return a 404 because the cache has not caught up. When you read straight after creating, add:
Consistency: Strong
Wrap-up
With one Compose action and one HTTP request you can stand up a full Dataverse table — primary column, numbers, currency, dates, and both flavours of choice — without touching the maker portal. Because the whole definition is just JSON, you can version it, parameterise it, or drive it from a CSV or SharePoint list to build tables on demand.
The same EntityDefinitions endpoint also handles updates (PUT) and lets you add columns to an existing table later (POST to its Attributes collection), so this is a solid foundation for any metadata-as-code approach on the Power Platform.
Quick reference: column type to @odata.type
| Column type you want | @odata.type to use |
|---|---|
| Single line of text | StringAttributeMetadata |
| Multiple lines of text | MemoAttributeMetadata |
| Whole number | IntegerAttributeMetadata |
| Big integer | BigIntAttributeMetadata |
| Decimal number | DecimalAttributeMetadata |
| Float | DoubleAttributeMetadata |
| Currency | MoneyAttributeMetadata |
| Yes/No | BooleanAttributeMetadata |
| Date and time | DateTimeAttributeMetadata |
| Choice (single) | PicklistAttributeMetadata |
| Choices (multi) | MultiSelectPicklistAttributeMetadata |
Full flow JSON
Here is the complete flow, scrubbed of environment-specific values. Before you use it, replace two placeholders:
yourorg.crm.dynamics.comin the HTTP action URL with your own environment URL.- The connection details (
connectionName,connectionReferenceLogicalName) will be set automatically when you add your own HTTP with Microsoft Entra ID connection — the placeholder values below are only there to keep the JSON valid.
Note: the
@@odata.typedouble-@is correct for this Power Automate definition (it is how the editor escapes a literal@). Keep it as-is when pasting into the flow editor's code view. If you ever send the body straight to Dataverse outside Power Automate, use a single@odata.type.
{
"$schema": "https://power-automate-tools.local/flow-editor.json#",
"connectionReferences": {
"shared_webcontents": {
"connectionName": "shared-webcontents-00000000-0000-0000-0000-000000000000",
"connectionReferenceLogicalName": "new_sharedwebcontents_xxxxx",
"source": "Invoker",
"id": "/providers/Microsoft.PowerApps/apis/shared_webcontents",
"displayName": "HTTP with Microsoft Entra ID (preauthorized)",
"iconUri": "https://conn-afd-prod-endpoint-bmc9bqahasf3grgk.b01.azurefd.net/releases/v1.0.1800/1.0.1800.4648/webcontents/icon.png",
"brandColor": "",
"tier": "Premium",
"apiName": "webcontents",
"isProcessSimpleApiReferenceConversionAlreadyDone": false
}
},
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"contentVersion": "undefined",
"parameters": {
"$authentication": {
"defaultValue": {},
"type": "SecureObject"
},
"$connections": {
"defaultValue": {},
"type": "Object"
}
},
"triggers": {
"manual": {
"type": "Request",
"kind": "Button",
"inputs": {
"schema": {
"type": "object",
"properties": {},
"required": []
}
}
}
},
"actions": {
"Compose_Table_Definition": {
"runAfter": {},
"type": "Compose",
"inputs": {
"@@odata.type": "Microsoft.Dynamics.CRM.EntityMetadata",
"SchemaName": "new_SampleProduct",
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Sample Product",
"LanguageCode": 1033
}
]
},
"DisplayCollectionName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Sample Products",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "A demo table that shows every common column type.",
"LanguageCode": 1033
}
]
},
"OwnershipType": "UserOwned",
"IsActivity": false,
"HasActivities": false,
"HasNotes": false,
"Attributes": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.StringAttributeMetadata",
"AttributeType": "String",
"AttributeTypeName": {
"Value": "StringType"
},
"SchemaName": "new_ProductName",
"IsPrimaryName": true,
"MaxLength": 100,
"FormatName": {
"Value": "Text"
},
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Product Name",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Primary name column (Single line of text).",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.MemoAttributeMetadata",
"AttributeType": "Memo",
"AttributeTypeName": {
"Value": "MemoType"
},
"SchemaName": "new_Description",
"Format": "TextArea",
"MaxLength": 2000,
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Description",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Multiple lines of text.",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.IntegerAttributeMetadata",
"AttributeType": "Integer",
"AttributeTypeName": {
"Value": "IntegerType"
},
"SchemaName": "new_Quantity",
"Format": "None",
"MinValue": 0,
"MaxValue": 1000000,
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Quantity",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Whole number.",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.BigIntAttributeMetadata",
"AttributeType": "BigInt",
"AttributeTypeName": {
"Value": "BigIntType"
},
"SchemaName": "new_SerialNumber",
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Serial Number",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Big integer (large whole number).",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.DecimalAttributeMetadata",
"AttributeType": "Decimal",
"AttributeTypeName": {
"Value": "DecimalType"
},
"SchemaName": "new_Weight",
"MinValue": 0,
"MaxValue": 100000,
"Precision": 2,
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Weight",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Decimal number.",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.DoubleAttributeMetadata",
"AttributeType": "Double",
"AttributeTypeName": {
"Value": "DoubleType"
},
"SchemaName": "new_Rating",
"MinValue": 0,
"MaxValue": 1000000,
"Precision": 2,
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Rating",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Float (floating point number).",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.MoneyAttributeMetadata",
"AttributeType": "Money",
"AttributeTypeName": {
"Value": "MoneyType"
},
"SchemaName": "new_Price",
"PrecisionSource": 2,
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Price",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Currency.",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.BooleanAttributeMetadata",
"AttributeType": "Boolean",
"AttributeTypeName": {
"Value": "BooleanType"
},
"SchemaName": "new_IsActive",
"DefaultValue": false,
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"OptionSet": {
"OptionSetType": "Boolean",
"TrueOption": {
"Value": 1,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Yes",
"LanguageCode": 1033
}
]
}
},
"FalseOption": {
"Value": 0,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "No",
"LanguageCode": 1033
}
]
}
}
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Is Active",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Yes/No.",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.DateTimeAttributeMetadata",
"AttributeType": "DateTime",
"AttributeTypeName": {
"Value": "DateTimeType"
},
"SchemaName": "new_ReceivedDate",
"Format": "DateAndTime",
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Received Date",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Date and time. Use Format DateOnly for date only.",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.PicklistAttributeMetadata",
"AttributeType": "Picklist",
"AttributeTypeName": {
"Value": "PicklistType"
},
"SchemaName": "new_Category",
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"OptionSet": {
"@@odata.type": "Microsoft.Dynamics.CRM.OptionSetMetadata",
"IsGlobal": false,
"OptionSetType": "Picklist",
"Options": [
{
"Value": 100000000,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Electronics",
"LanguageCode": 1033
}
]
}
},
{
"Value": 100000001,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Apparel",
"LanguageCode": 1033
}
]
}
},
{
"Value": 100000002,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Grocery",
"LanguageCode": 1033
}
]
}
}
]
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Category",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Choice (single select).",
"LanguageCode": 1033
}
]
}
},
{
"@@odata.type": "Microsoft.Dynamics.CRM.MultiSelectPicklistAttributeMetadata",
"AttributeType": "Virtual",
"AttributeTypeName": {
"Value": "MultiSelectPicklistType"
},
"SchemaName": "new_Tags",
"RequiredLevel": {
"Value": "None",
"CanBeChanged": true,
"ManagedPropertyLogicalName": "canmodifyrequirementlevelsettings"
},
"OptionSet": {
"@@odata.type": "Microsoft.Dynamics.CRM.OptionSetMetadata",
"IsGlobal": false,
"OptionSetType": "Picklist",
"Options": [
{
"Value": 100000000,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "New",
"LanguageCode": 1033
}
]
}
},
{
"Value": 100000001,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Featured",
"LanguageCode": 1033
}
]
}
},
{
"Value": 100000002,
"Label": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "On Sale",
"LanguageCode": 1033
}
]
}
}
]
},
"DisplayName": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Tags",
"LanguageCode": 1033
}
]
},
"Description": {
"@@odata.type": "Microsoft.Dynamics.CRM.Label",
"LocalizedLabels": [
{
"@@odata.type": "Microsoft.Dynamics.CRM.LocalizedLabel",
"Label": "Choices (multi select).",
"LanguageCode": 1033
}
]
}
}
]
}
},
"Invoke_an_HTTP_request": {
"runAfter": {
"Compose_Table_Definition": [
"Succeeded"
]
},
"type": "OpenApiConnection",
"inputs": {
"parameters": {
"request/method": "POST",
"request/url": "https://yourorg.crm.dynamics.com/api/data/v9.2/EntityDefinitions",
"request/headers": {
"Content-Type": "application/json; charset=utf-8",
"OData-MaxVersion": "4.0",
"OData-Version": "4.0",
"Accept": "application/json"
},
"request/body": "@outputs('Compose_Table_Definition')"
},
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_webcontents",
"operationId": "InvokeHttp",
"connectionName": "shared_webcontents"
},
"retryPolicy": {
"type": "none"
}
}
}
}
}
}
