Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : O2CGsJ8ZRJwuq0BCzBHoJ9
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Relating Rows in Datav...
Power Apps - Microsoft Dataverse
Answered

Relating Rows in Dataverse when Importing both Tables via Dataflows

Like (1) ShareShare
ReportReport
Posted on 24 Apr 2024 23:39:29 by ekru222 69

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
  • SAlluri Profile Picture
    SAlluri 66 on 25 Apr 2024 at 21:34:47
    Re: Relating Rows in Dataverse when Importing both Tables via Dataflows

    SAlluri_0-1714080815711.png

     

    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

  • ekru222 Profile Picture
    ekru222 69 on 25 Apr 2024 at 21:02:46
    Re: Relating Rows in Dataverse when Importing both Tables via Dataflows

    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.

  • Verified answer
    SAlluri Profile Picture
    SAlluri 66 on 25 Apr 2024 at 09:54:09
    Re: Relating Rows in Dataverse when Importing both Tables via Dataflows

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans