{{ transformations:ImportMicrosoftDataverseAction.png}}
====== IMPORT FROM MICROSOFT DATAVERSE======
Category: Import / App/Cloud\\

\\ 
=====Description=====
This action imports data and metadata from a Microsoft Dataverse environment.\\

\\ 
=====Action settings=====
^ Setting  ^ Description  ^
|Connector<sup>*</sup>|Select a configured [[connectors:dataverse|Microsoft Dataverse connector]].|
|Command|Select the process to perform in the Dataverse environment.  Options:  //Import entity//, //List entities//, or //List entity columns//.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\
====Import entity settings====
^ Setting  ^ Description  ^
|Entity<sup>*</sup>|Enter or select the Dataverse entity to import.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\
===Columns tab===
^ Setting  ^ Description  ^
|Import all columns|Choose this option to import all columns of the selected entity.|
|Import selected columns|Choose this option to import specific columns and select those columns from the list that appears.|
\\
===Filter tab===
^ Setting  ^ Description  ^
|Load the first|Check this option //on// to import a limited number of rows from the top of the entity. Specify the number of rows to import<sup>*</sup>.|
|Add filter|Choose this to add one or more filters to the imported data.  Options: //Simple filter// (and enter the values<sup>*</sup> to build\\ the filter, or //Custom OData filter// (and enter an OData filter query<sup>*</sup>).|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\
====List entities===
**Description:** Choose this Command to list all entities found in the Dataverse environment.

\\
====List entity columns====
^ Setting  ^ Description  ^
|Entity<sup>*</sup>|Enter or select an entity to list the columns of.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\ 
=====Shortcuts=====
Fast ways to create the action:
  * Press the "Add data" menu button. Pick "Fetch from cloud/application".

\\ 
=====See also=====
  *[[connectors:dataverse|Microsoft Dataverse connector]]
  *[[transformations:importpowerbi|Import from Power BI]]
  *[[transformations:importsharepointlist|Import Sharepoint list]]