Power Platform Community Forum Thread Details

Hello Community,

I am relatively new to the Microsoft Teams and PowerApps / Dataverse world and have a question about the DataFlow Connector in Power Apps.

I have created a Dataflow (Dataflow1) in Teams that uses files from Sharepoint as a data source and loads them into two tables.
This works very well, I am quite satisfied.

Now I want to process the result of Dataflow1 in a second Dataflow (Dataflow2).

I thought this was possible with the connector "Dataflow - PowerPlatform", but I don't get access to the tables/the Dataflow1.

When I create a new dataflow and select the connector "Dataflow - Powerplatform", the team and the corresponding dataflows are displayed under Environments.
However, I can only select "not published" flows as source and I get an error here as well

(422) "Web.Contents": Unprocessable EntityDetailsDataSourceKind = PowerPlatformDataflows
DataSourcePath = PowerPlatformDataflows"

Can I reference an existing DataFlow in the same team in a DataFlow ?

EDIT1:

I've managed to connect to the data with powerbi by choosing "DataVerse - PowerPlatform" as Connector, power bi generates a step with the source

"= CommonDataService.Database("hereisaurl.com")"

When i try to reproduce these steps within Power Automate for Teams i get the error:

DataSource.Error: Microsoft SQL: The 'ExecutePowerBISql' message is not supported for the Dataverse for Teams offering RequestId: xxx Time: yyyy

The region im working in is central europe.

Could this feature be unavailable within PowerApps for Teams or even in my region?

Many greetings

Categories:

Microsoft Dataverse with Power Apps

Update1:

I coudn't manage to connect the two dataflows with the Dataflow connector or the Dataverse connector.

But i found a solution to access the data/ table:

Situation is:
- Dataverse for Teams

- Dataflow1 creates two tables

- Dataflow2 should use tables from Dataflow1 as source

The Microsoft Documentation showed a possible solution using OData.Feed

Migrate data between Microsoft Dataverse environments using the dataflows OData connector - Power Apps | Microsoft Docs

Here's how i managed to get it work:

1. Get the Instance URL for the Environments by

1.1 clicking the "Info" tab in Power Apps for Teams

1.2 clicking "Session Details"

1.3 Get the value of "Instance url" i.e. https://<yourvalueshere>.crm4.dynamics.com/

1.4 modify the url by adding "/api/data/v9.2/"

to get the final url (https://<yourvalueshere>.crm4.dynamics.com/api/data/v9.2/)

2. Follow the above linked microsoft documentation to access the dataverse using OData.Feed

2.1 I had some issues with the authentication and my organisational account. When i pressed the "Sign in" button in Power Apps for Teams, edge would open a new tab and close it immediately. I found a workaound by opening Power Apps for Teams in PowerApps using the three dots (...) next to your Team Name in Power Apps for Teams.