Microsoft Dataverse

Provides access to Microsoft Dataverse actions and triggers for Power Platform environments.

This connector is available in the following products and regions:

Service Class Regions
Copilot Studio Premium All Power Automate regions
Power Apps Premium All Power Apps regions
Power Automate Premium All Power Automate regions
Contact
Name Microsoft
URL https://make.powerautomate.com/en-us/support/
Connector Metadata
Publisher Microsoft
Website https://make.powerautomate.com/
Privacy policy https://privacy.microsoft.com
Categories Data

Creating a connection

The connector supports the following authentication types:
Client Certificate Auth Provide Microsoft Entra ID credentials using PFX certificate and password All regions Shareable
Oauth Oauth All regions Not shareable
Service Principal Provide Microsoft Entra ID credentials using Client Id and Secret All regions Shareable
Default [DEPRECATED] This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility. All regions Not shareable

Client Certificate Auth

Auth ID: CertOauth

Applicable: All regions

Provide Microsoft Entra ID credentials using PFX certificate and password

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
Tenant string True
Client ID string The client ID of for the Microsoft Entra ID application True
Client certificate secret clientCertificate The client certificate secret allowed by this application True

Oauth

Auth ID: Oauth

Applicable: All regions

Oauth

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Service Principal

Auth ID: ServicePrincipalOauth

Applicable: All regions

Provide Microsoft Entra ID credentials using Client Id and Secret

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
Client ID string Client (or Application) ID of the Microsoft Entra ID application. True
Client Secret securestring Client secret of the Microsoft Entra ID application. True
Tenant string The tenant ID of for the Microsoft Entra ID application. True

Default [DEPRECATED]

Applicable: All regions

This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Throttling Limits

Name Calls Renewal Period
API calls per connection 6000 300 seconds

Actions

Add a new row

This action allows you to add a new row in the selected Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).
Add a new row to selected environment

Create a new row in a table in a Power Platform environment.
Ask using semantic model

Asks a natural-language question about data in the selected Microsoft Dataverse semantic model.
Ask using semantic model from selected environment

Asks a natural-language question about data in a Microsoft Dataverse semantic model in the selected environment.
Create semantic model

Creates a semantic model from the selected Microsoft Dataverse tables.
Create semantic model from selected environment

Creates a semantic model from selected Microsoft Dataverse tables in the selected environment.
Delete a row

This action allows you to delete a row from a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).
Delete a row from selected environment

Delete a row from a table in a Power Platform environment.
Delete semantic model

Deletes the selected semantic model. This action does not delete the underlying Microsoft Dataverse tables or their data.
Delete semantic model from selected environment

Deletes the selected semantic model from the selected environment. This action does not delete the underlying Microsoft Dataverse tables or their data.
Download a file or an image

This action allows you to download a file or an image content from a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).
Download a file or an image from selected environment

Retrieve file or image data from a row in a Power Platform environment.
Get a row by ID

This action allows you to get the row that matches an ID in a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).
Get a row by ID from selected environment

Get a row from a table in a Power Platform environment.
List rows

This action allows you to list the rows in a Microsoft Dataverse table that match the selected options. This connector was formerly known as Common Data Service (current environment).
List rows from selected environment

List rows from a table in a Power Platform environment.
List semantic models

Retrieves the semantic models available in the selected Microsoft Dataverse environment.
List semantic models from selected environment

Retrieves the semantic models available in the selected Microsoft Dataverse environment.
Microsoft Dataverse MCP Server (Preview)

Provides Remote MCP Server access to Dataverse
Microsoft Dataverse MCP Server (Preview) (Preview)

Provides Remote MCP Server access to Dataverse with preview tools
Perform a background operation (preview)

This action allows you to perform Microsoft Dataverse operations in the background using Custom APIs that are not classified as functions. The list of APIs listed in the dropdown menu are only compatible APIs with this action.
Perform a bound action

This action allows you to perform Microsoft Dataverse actions associated with a selected table. This connector was formerly known as Common Data Service (current environment).
Perform a bound action in selected environment

Run a Dataverse action bound to a table in a Power Platform environment, including custom actions.
Perform a changeset request

This action allows you to perform a group of Microsoft Dataverse connector operations as a single transaction. If one of the operations fails, all the successful actions are rolled back. This connector was formerly known as Common Data Service (current environment).
Perform an unbound action

This action allows you to perform Microsoft Dataverse actions available in the environment that are not associated with any table. This connector was formerly known as Common Data Service (current environment).
Perform an unbound action in selected environment

Run a global Dataverse action in a Power Platform environment, including custom actions.
Relate rows

This action allows you to link a row in one Microsoft Dataverse table to another if the tables have a one-to-many or many-to-many relationship. This connector was formerly known as Common Data Service (current environment).
Relate rows in selected environment

Associate individual rows in tables that have a one-to-many or many-to-many relationship in the same Power Platform environment.
Search rows (preview)

This action allows you to search a Microsoft Dataverse environment using Relevance Search, and returns the rows that match the search term most closely. This connector was formerly known as Common Data Service (current environment).
Unrelate rows

This action allows you to remove the link between a row in one Microsoft Dataverse table to another if the tables have a one-to-many or many-to-many relationship. This connector was formerly known as Common Data Service (current environment).
Unrelate rows in selected environment

Remove the association between individual rows in a Power Platform environment.
Update a row

This action allows you to modify any selected row in a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).
Update a row in selected environment

Update a row in a table in a Power Platform environment.
Upload a file or an image

This action allows you to upload a file or an image content to a Microsoft Dataverse table with a compatible column type. This connector was formerly known as Common Data Service (current environment).
Upload a file or an image to selected environment

Update file or image content in a row in a Power Platform environment.
Upsert a row

This action allows you to modify any selected row in a Microsoft Dataverse table, or adds a new row if it doesn’t exist. This connector was formerly known as Common Data Service (current environment).
Upsert a row in selected environment

Update or add (upsert) a row in a table in a Power Platform environment.

Add a new row

Operation ID:
CreateRecord

This action allows you to add a new row in the selected Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Table name
 entityName True string

Choose a table
object

Returns

response
object

Add a new row to selected environment

Operation ID:
CreateRecordWithOrganization

Create a new row in a table in a Power Platform environment.

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row Item
 item True dynamic

Row to create

Returns

The outputs of this operation are dynamic.

Ask using semantic model

Operation ID:
AskUsingSemanticModel

Asks a natural-language question about data in the selected Microsoft Dataverse semantic model.

Parameters

Name Key Required Type Description
Question
 query True string

Enter a natural-language question about the data in the semantic model.
Semantic model name
 semanticModelName True string

Enter the unique name of the semantic model that contains the data to query.
Search mode
 searchMode string

The search mode to use when answering the question.
Row count
 count integer

The maximum number of matching rows to return. The default is 100.
Paging token
 pagingToken string

To retrieve the next page, enter the paging token returned by the previous response.

Returns

The answer and supporting results returned for the question.

Body
IqAskResponse

Ask using semantic model from selected environment

Operation ID:
AskUsingSemanticModelWithOrganization

Asks a natural-language question about data in a Microsoft Dataverse semantic model in the selected environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Question
 query True string

Enter a natural-language question about the data in the semantic model.
Semantic model name
 semanticModelName True string

Enter the unique name of the semantic model that contains the data to query.
Search mode
 searchMode string

The search mode to use when answering the question.
Row count
 count integer

The maximum number of matching rows to return. The default is 100.
Paging token
 pagingToken string

To retrieve the next page, enter the paging token returned by the previous response.

Returns

The answer and supporting results returned for the question.

Body
IqAskResponse

Create semantic model

Operation ID:
CreateSemanticModel

Creates a semantic model from the selected Microsoft Dataverse tables.

Parameters

Name Key Required Type Description
Unique name
 uniqueName True string

Enter a name that uniquely identifies the semantic model in this environment.
Tables
 tables True array of string

The logical names of the Microsoft Dataverse tables to include in the semantic model.

Returns

The result of creating a semantic model.

Body
IqSemanticModelCreateResponse

Create semantic model from selected environment

Operation ID:
CreateSemanticModelWithOrganization

Creates a semantic model from selected Microsoft Dataverse tables in the selected environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Unique name
 uniqueName True string

Enter a name that uniquely identifies the semantic model in this environment.
Tables
 tables True array of string

The logical names of the Microsoft Dataverse tables to include in the semantic model.

Returns

The result of creating a semantic model.

Body
IqSemanticModelCreateResponse

Delete a row

Operation ID:
DeleteRecord

This action allows you to delete a row from a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Partition Id
 partitionId string

An option to specify the partitionId while deleting row for NoSQL tables

Delete a row from selected environment

Operation ID:
DeleteRecordWithOrganization

Delete a row from a table in a Power Platform environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Partition Id
 partitionId string

An option to specify the partitionId while deleting row for NoSQL tables

Delete semantic model

Operation ID:
DeleteSemanticModel

Deletes the selected semantic model. This action does not delete the underlying Microsoft Dataverse tables or their data.

Parameters

Name Key Required Type Description
Semantic model ID
 id True string

Enter the ID of the semantic model to delete.

Returns

The result of deleting a semantic model.

Body
IqSemanticModelDeleteResponse

Delete semantic model from selected environment

Operation ID:
DeleteSemanticModelWithOrganization

Deletes the selected semantic model from the selected environment. This action does not delete the underlying Microsoft Dataverse tables or their data.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Semantic model ID
 id True string

Enter the ID of the semantic model to delete.

Returns

The result of deleting a semantic model.

Body
IqSemanticModelDeleteResponse

Download a file or an image

Operation ID:
GetEntityFileImageFieldContent

This action allows you to download a file or an image content from a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Column name
 fileImageFieldName True string

Choose a column
Image size
 size string

Enter 'full' for entire image if enabled (default = thumbnail)

Returns

The content of the file or image

File or image content
binary

Download a file or an image from selected environment

Operation ID:
GetEntityFileImageFieldContentWithOrganization

Retrieve file or image data from a row in a Power Platform environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Column name
 fileImageFieldName True string

Choose a column
Image size
 size string

Enter 'full' for entire image if enabled (default = thumbnail)

Returns

The content of the file or image

File or image content
binary

Get a row by ID

Operation ID:
GetItem

This action allows you to get the row that matches an ID in a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Select columns
 $select string

Enter a comma-separated list of column unique names to limit which columns are listed
Expand Query
 $expand string

Enter an Odata style expand query to list related rows
Partition Id
 partitionId string

An option to specify the partitionId while retrieving data for NoSQL tables

Returns

response
object

Get a row by ID from selected environment

Operation ID:
GetItemWithOrganization

Get a row from a table in a Power Platform environment.

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Environment
 organization True string

Choose an environment
Extract Sensitivity Label
 MSCRM.IncludeMipSensitivityLabel boolean

Select if you want to fetch Sensitivity Label ID
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Select columns
 $select string

Enter a comma-separated list of column unique names to limit which columns are listed
Expand Query
 $expand string

Enter an Odata style expand query to list related rows
Partition Id
 partitionId string

An option to specify the partitionId while retrieving data for NoSQL tables

Returns

The outputs of this operation are dynamic.

List rows

Operation ID:
ListRecords

This action allows you to list the rows in a Microsoft Dataverse table that match the selected options. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Table name
 entityName True string

Choose a table
Select columns
 $select string

Enter a comma-separated list of column unique names to limit which columns are listed
Filter rows
 $filter string

Enter an OData style filter expression to limit which rows are listed
Sort By
 $orderby string

Columns to sort by in OData orderBy style (excluding lookups)
Expand Query
 $expand string

Enter an Odata style expand query to list related rows
Fetch Xml Query
 fetchXml string

Enter a Fetch XML query for advanced customization
Row count
 $top integer

Enter the number of rows to be listed (default = 5000)
Skip token
 $skiptoken string

Enter the skip token obtained from a previous run to list rows from the next page
Partition ID
 partitionId string

An option to specify the partitionId while retrieving data for NoSQL tables

Returns

List of tables

Body
EntityItemList

List rows from selected environment

Operation ID:
ListRecordsWithOrganization

List rows from a table in a Power Platform environment.

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Environment
 organization True string

Choose an environment
Extract Sensitivity Label
 MSCRM.IncludeMipSensitivityLabel boolean

Select if you want to fetch Sensitivity Label ID
Table name
 entityName True string

Choose a table
Select columns
 $select string

Enter a comma-separated list of column unique names to limit which columns are listed
Filter rows
 $filter string

Enter an OData style filter expression to limit which rows are listed
Sort By
 $orderby string

Columns to sort by in OData orderBy style (excluding lookups)
Expand Query
 $expand string

Enter an Odata style expand query to list related rows
Fetch Xml Query
 fetchXml string

Enter a Fetch XML query for advanced customization
Row count
 $top integer

Enter rows to list. The default is 2000. Enable paging in settings for more rows.
Skip token
 $skiptoken string

Enter the skip token obtained from a previous run to list rows from the next page
Partition ID
 partitionId string

An option to specify the partitionId while retrieving data for NoSQL tables

Returns

The outputs of this operation are dynamic.

List semantic models

Operation ID:
ListSemanticModels

Retrieves the semantic models available in the selected Microsoft Dataverse environment.

Parameters

Name Key Required Type Description
Include agent information
 include string

Select botinfo to include information about the agents associated with each semantic model.

Returns

The semantic models available in the selected Dataverse environment.

Body
IqSemanticModelListResponse

List semantic models from selected environment

Operation ID:
ListSemanticModelsWithOrganization

Retrieves the semantic models available in the selected Microsoft Dataverse environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Include agent information
 include string

Select botinfo to include information about the agents associated with each semantic model.

Returns

The semantic models available in the selected Dataverse environment.

Body
IqSemanticModelListResponse

Microsoft Dataverse MCP Server (Preview)

Operation ID:
InvokeMCP

Provides Remote MCP Server access to Dataverse

Microsoft Dataverse MCP Server (Preview) (Preview)

Operation ID:
InvokeMCPPreview

Provides Remote MCP Server access to Dataverse with preview tools

Perform a background operation (preview)

Operation ID:
PerformBackgroundOperation

This action allows you to perform Microsoft Dataverse operations in the background using Custom APIs that are not classified as functions. The list of APIs listed in the dropdown menu are only compatible APIs with this action.

Parameters

Name Key Required Type Description
Dynamic Items
 item True dynamic

Dynamic Items
Catalog
 catalog True string

Choose a catalog to filter tables and actions.
Category
 category True string

Choose a category to filter tables and actions.
Action name
 actionName True string

Choose an action.

Returns

The action response object which includes background operation state code and status code.

Body
WebhookNotificationContentForPerformBackgroundOperation

Perform a bound action

Operation ID:
PerformBoundAction

This action allows you to perform Microsoft Dataverse actions associated with a selected table. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Table name
 entityName True string

Choose a table
Action Name
 actionName True string

Choose an action
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
object

Returns

response
object

Perform a bound action in selected environment

Operation ID:
PerformBoundActionWithOrganization

Run a Dataverse action bound to a table in a Power Platform environment, including custom actions.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Action Name
 actionName True string

Choose an action
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Action parameters
 item dynamic

Action parameters

Returns

The outputs of this operation are dynamic.

Perform a changeset request

Operation ID:
ExecuteChangeset

This action allows you to perform a group of Microsoft Dataverse connector operations as a single transaction. If one of the operations fails, all the successful actions are rolled back. This connector was formerly known as Common Data Service (current environment).

Perform an unbound action

Operation ID:
PerformUnboundAction

This action allows you to perform Microsoft Dataverse actions available in the environment that are not associated with any table. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Action Name
 actionName True string

Choose an action
object

Returns

response
object

Perform an unbound action in selected environment

Operation ID:
PerformUnboundActionWithOrganization

Run a global Dataverse action in a Power Platform environment, including custom actions.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Action Name
 actionName True string

Choose an action
Action parameters
 item dynamic

Action parameters

Returns

The outputs of this operation are dynamic.

Relate rows

Operation ID:
AssociateEntities

This action allows you to link a row in one Microsoft Dataverse table to another if the tables have a one-to-many or many-to-many relationship. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Relationship
 associationEntityRelationship True string

Choose relationship type
Relate with
 @odata.id True string

Enter the row URL using OData ID from a previous step or typing the full URL (eg. https://org0.crm.dynamics.com/api/data/v9.0/faxes(3ce6c728-3c8a-4b55-a4ee-a251b253c3ee)

Relate rows in selected environment

Operation ID:
AssociateEntitiesWithOrganization

Associate individual rows in tables that have a one-to-many or many-to-many relationship in the same Power Platform environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Relationship
 associationEntityRelationship True string

Choose relationship type
Relate with
 @odata.id True string

Enter the row URL using OData ID from a previous step or typing the full URL (eg. https://org0.crm.dynamics.com/api/data/v9.0/faxes(3ce6c728-3c8a-4b55-a4ee-a251b253c3ee)

Search rows (preview)

Operation ID:
GetRelevantRows

This action allows you to search a Microsoft Dataverse environment using Relevance Search, and returns the rows that match the search term most closely. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Search term
 search True string

Enter a search term, eg. Contoso. Searches modifiers like boolean operators, wildcards, fuzzy search, proximity search etc. require the search type full
Search type
 searchtype string

Enter whether simple or full search syntax should be used (default is simple)
Search mode
 searchmode string

Enter whether any or all of the search terms must be matched (default is any)
Row count
 top integer

Enter the number of search results to be listed (default = 50)
Row filter
 filter string

Enter an Odata style filter expression to narrow the search
Table filter
 entities array of string

Enter a comma-separated list of tables to be searched (default is all tables)
Sort by
 orderby array of string

Enter a comma-separated list of column unique names followed by asc or desc
Facet query
 facets array of string

Enter a comma-separated list of facet queries to narrow the search
Skip rows
 skip integer

Enter the number of search results to be skipped
Return row count
 returntotalrecordcount boolean

Choose an option

Returns

The search output.

Body
SearchOutput

Unrelate rows

Operation ID:
DisassociateEntities

This action allows you to remove the link between a row in one Microsoft Dataverse table to another if the tables have a one-to-many or many-to-many relationship. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Relationship
 associationEntityRelationship True string

Choose relationship type
Unrelate with
 $id True string

Enter the row URL using OData ID from a previous step or typing the full URL (eg. https://org0.crm.dynamics.com/api/data/v9.0/faxes(3ce6c728-3c8a-4b55-a4ee-a251b253c3ee)

Unrelate rows in selected environment

Operation ID:
DisassociateEntitiesWithOrganization

Remove the association between individual rows in a Power Platform environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Relationship
 associationEntityRelationship True string

Choose relationship type
Unrelate with
 $id True string

Enter the row URL using OData ID from a previous step or typing the full URL (eg. https://org0.crm.dynamics.com/api/data/v9.0/faxes(3ce6c728-3c8a-4b55-a4ee-a251b253c3ee)

Update a row

Operation ID:
UpdateOnlyRecord

This action allows you to modify any selected row in a Microsoft Dataverse table. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
object

Returns

response
object

Update a row in selected environment

Operation ID:
UpdateOnlyRecordWithOrganization

Update a row in a table in a Power Platform environment.

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Row Item
 item True dynamic

Row to update

Returns

The outputs of this operation are dynamic.

Upload a file or an image

Operation ID:
UpdateEntityFileImageFieldContent

This action allows you to upload a file or an image content to a Microsoft Dataverse table with a compatible column type. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Column name
 fileImageFieldName True string

Choose a column
Content
 item True binary

Add file or image content
Content name
 x-ms-file-name True string

Enter a name for the file or image

Upload a file or an image to selected environment

Operation ID:
UpdateEntityFileImageFieldContentWithOrganization

Update file or image content in a row in a Power Platform environment.

Parameters

Name Key Required Type Description
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Column name
 fileImageFieldName True string

Choose a column
Content
 item True binary

Add file or image content
Content name
 x-ms-file-name True string

Enter a name for the file or image

Upsert a row

Operation ID:
UpdateRecord

This action allows you to modify any selected row in a Microsoft Dataverse table, or adds a new row if it doesn’t exist. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
object

Returns

response
object

Upsert a row in selected environment

Operation ID:
UpdateRecordWithOrganization

Update or add (upsert) a row in a table in a Power Platform environment.

Parameters

Name Key Required Type Description
Return Full Metadata
 x-ms-odata-metadata-full boolean

The header parameter to customer to opt-in returning full odata metadata in response.
Environment
 organization True string

Choose an environment
Table name
 entityName True string

Choose a table
Row ID
 recordId True string

Enter the row's globally unique identifier (GUID)
Row Item
 item True dynamic

Row to update

Returns

The outputs of this operation are dynamic.

Triggers

When a row is added, modified or deleted

This trigger allows you to start a flow when a row is added, modified or deleted in a Microsoft Dataverse table, such that it matches the selected options. This connector was formerly known as Common Data Service (current environment).
When an action is performed

Triggers when a Microsoft Dataverse action has completed.

When a row is added, modified or deleted

Operation ID:
SubscribeWebhookTrigger

This trigger allows you to start a flow when a row is added, modified or deleted in a Microsoft Dataverse table, such that it matches the selected options. This connector was formerly known as Common Data Service (current environment).

Parameters

Name Key Required Type Description
Change type
 message True integer

Choose when the flow triggers
Table name
 entityname True string

Choose a table
Scope
 scope True integer

Choose a scope to limit which rows can trigger the flow
Select columns
 filteringattributes string

Enter a comma-separated list of column unique names. The flow triggers if any of the columns is present in the update payload regardless of if data is modified
Filter rows
 filterexpression string

Odata expression to limit rows that can trigger the flow, eg. statecode eq 0
Delay until
 postponeuntil string

Enter a time to delay the trigger evaluation, eg. 2020-01-01T10:10:00Z
Run as
 runas integer

Choose the running user for steps where invoker connections are used

Returns

A Table item.

Body
WebhookNotificationContent

When an action is performed

Operation ID:
BusinessEventsTrigger

Triggers when a Microsoft Dataverse action has completed.

Parameters

Name Key Required Type Description
Catalog
 catalog True string

Choose an option to filter tables and actions.
Category
 category True string

Choose an option to filter tables and actions.
Table name
 entityname True string

Choose a table to filter actions.
Action name
 sdkmessagename True string

Choose an action.

Returns

An action and table item.

Body
WebhookNotificationContentForWhenAnActionIsPerformed

Definitions

EntityItemList

List of tables

Name Path Type Description
value
 value array of EntityItem

List of Items
Next link
 @odata.nextLink string

The url to fetch next page data.

EntityItem

A Table item

Name Path Type Description
dynamicProperties
 dynamicProperties object

Object

WebhookNotificationContent

A Table item.

Name Path Type Description
schema
 schema Object

SearchOutput

The search output.

Name Path Type Description
List of rows
 value array of object

List of rows
Row search score
 value.@search.score number

Search score of row
Row table name
 value.@search.entityname string

Table that contains the row
Row object id
 value.@search.objectid string

Objectid of row
Row object type code
 value.@search.objecttypecode integer

Objecttypecode of row
Total row count
 totalrecordcount integer

Total count of results (-1 if returntotalrecordcount is set to false)

IqSemanticModelCreateResponse

The result of creating a semantic model.

Name Path Type Description
data
 data IqSemanticModelCreateData

Information about the semantic model that was created.
Message
 message string

A message that describes the result of the create action.

IqSemanticModelCreateData

Information about the semantic model that was created.

Name Path Type Description
Semantic model ID
 id string

The ID of the semantic model that was created.
Unique name
 uniqueName string

The unique name of the semantic model that was created.
Created on
 createdOn date-time

The date and time when the semantic model was created.

IqSemanticModelDeleteResponse

The result of deleting a semantic model.

Name Path Type Description
data
 data IqSemanticModelDeleteData

Information about the semantic model that was deleted.
Message
 message string

A message that describes the result of the delete action.

IqSemanticModelDeleteData

Information about the semantic model that was deleted.

Name Path Type Description
Semantic model ID
 id string

The ID of the semantic model that was deleted.

IqAskResponse

The answer and supporting results returned for the question.

Name Path Type Description
Raw result
 rawResult array of object

The matching data rows returned for the question.
items
 rawResult object
Citation links
 citationLinks array of string

Links to the sources used to produce the answer.
Summary
 summary string

A natural-language summary of the matching data.
Total result count
 totalResultCount integer

The total number of matching rows.
Paging token
 pagingToken string

The token to provide in the next request to retrieve the next page of results.

IqSemanticModelListResponse

The semantic models available in the selected Dataverse environment.

Name Path Type Description
Semantic models
 data array of IqSemanticModel

A list of semantic models available in the environment.

IqSemanticModel

Information about a Microsoft Dataverse semantic model.

Name Path Type Description
Semantic model ID
 id string

The ID of the semantic model.
Unique name
 uniqueName string

The unique name assigned to the semantic model.
Source
 source string

The application or service that created the semantic model.
Description
 description string

The description of the semantic model.
Owner
 owner string

The name of the user or team that owns the semantic model.
Tables
 tables array of string

The logical names of the Dataverse tables included in the semantic model.
Created by
 createdBy string

The name of the user who created the semantic model.
Modified on
 modifiedOn date-time

The date and time when the semantic model was last modified.
Created on
 createdOn date-time

The date and time when the semantic model was created.
Owner ID
 ownerId string

The ID of the user or team that owns the semantic model.
Primary Microsoft 365 app module ID
 m365AppModuleId string

The ID of the app module associated with an ALM-compliant primary semantic model. This value is backed by the DVTableSearch-to-AppModule lookup relationship.
Secondary Microsoft 365 app module ID
 m365AppModuleIdSecondary string

The app module ID associated with a secondary semantic model. This value is stored as a GUID and does not create an ALM-managed relationship to the app module.
Primary app module name
 appModulePrimaryName string

The display name of the app module referenced by m365AppModuleId.
Primary app module unique name
 appModulePrimaryUniqueName string

The logical name of the app module referenced by m365AppModuleId.
Secondary app module name
 appModuleSecondaryName string

The display name of the app module whose ID is stored in m365AppModuleIdSecondary.
Secondary app module unique name
 appModuleSecondaryUniqueName string

The logical name of the app module whose ID is stored in m365AppModuleIdSecondary.
Agents
 bots array of IqSemanticModelBotInfo

Information about the agents associated with the semantic model. Returned when Include agent information is set to botinfo.

IqSemanticModelBotInfo

Information about an agent associated with a semantic model.

Name Path Type Description
Agent component name
 botComponentName string

The internal name of the agent component.
Agent name
 agentName string

The name of the agent.

WebhookNotificationContentForWhenAnActionIsPerformed

An action and table item.

Name Path Type Description
schema
 schema Object

WebhookNotificationContentForPerformBackgroundOperation

The action response object which includes background operation state code and status code.

Name Path Type Description
schema
 schema Object

object

This is the type 'object'.

binary

This is the basic data type 'binary'.