Power Platform Dataflows (Preview)

Power Platform Dataflows

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following:      -   Azure China regions      -   US Department of Defense (DoD)

Connector Metadata
Publisher	Microsoft

Creating a connection

The connector supports the following authentication types:

Default	Parameters for creating connection.	All regions	Not shareable

Default

Applicable: All regions

Parameters for creating connection.

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	100	60 seconds

Actions

Get a dataflow's entities	This operation gets entities from a dataflow.
Get a dataflow entity's data	This operation gets data from a dataflow entity.
Gets dataflows	This operation gets all dataflows available in environment.

Get a dataflow's entities

Operation ID:

GetTables

This operation gets entities from a dataflow.

Parameters

Name	Key	Required	Type	Description
Name of dataflow	dataset	True	string	Name of dataflow

Returns

Represents a list of tables.

Body

TablesList

Get a dataflow entity's data

Operation ID:

GetItems

This operation gets data from a dataflow entity.

Parameters

Name	Key	Required	Type	Description
Name of dataflow	dataset	True	string	Name of dataflow
Name of entity	table	True	string	Name of entity
Filter Query	$filter		string	An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By	$orderby		string	An ODATA orderBy query for specifying the order of entries.
Top Count	$top		integer	Total number of entries to retrieve (default = all).
Skip Count	$skip		integer	The number of entries to skip (default = 0).
Select Query	$select		string	Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Gets dataflows

Operation ID:

GetDataSets

This operation gets all dataflows available in environment.

Returns

List of datasets

Body

DataSetsList

Definitions

DataSetsList

List of datasets

Name	Path	Type	Description
value	value	array of DataSet	List of datasets

DataSet

Dataset

Name	Path	Type	Description
Name	Name	string	Dataset name
DisplayName	DisplayName	string	Dataset display name

Table

Represents a table.

Name	Path	Type	Description
Name	Name	string	The name of the table. The name is used at runtime.
DisplayName	DisplayName	string	The display name of the table.

TablesList

Represents a list of tables.

Name	Path	Type	Description
value	value	array of Table	List of Tables