Answered

Relating Rows in Dataverse when Importing both Tables via Dataflows

(1) Share

Report

Posted on by ekru222

I've imported 2 Sharepoint lists into Dataverse Tables. After importing both, I created a relationship in Dataverse between the tables, a many-to-one relationship. The "one" table has 100 or so rows, the "many" table as a few thousand.

Is the most efficient way to relate the existing rows by creating a Power Automate flow and looping through each row on the "many" table? Is there any faster/better way to do so?

Also, when the source tables are updated with new information is a Power Automate flow after the Dataflow refresh has completed the best way to relate the new rows?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

SAlluri 66 on at

Like (1)

Report

I would try to relate the records via Dataflow it self..

you run the flow for primary table first (the one that is part of (1) in 1 to many relation), and then use dataverse connector to connect this table with the other table (the one which has many relation) and include the guid of the primary record while creating these many records.

obviously, you can use power automate as well for this purpose but from performance wise that may not be the option you want to go for ..

Thanks
-Srikanth

Was this reply helpful? Yes No
ekru222 69 on at

Like (0)

Report

Can you specify what you mean by the 'Dataverse Connector' here? I'm familiar with the Power Automate Dataverse Connector, but don't see how the connector is accessible within a Dataflow.

Was this reply helpful? Yes No
SAlluri 66 on at

Like (0)

Report

if for any reason that is not working for you, you should be able to use the WebAPI connector as well (2nd row 2nd one)

Thank you
-Srikanth

Was this reply helpful? Yes No