DataFlow to create multiple SETS of records in same entity

(0) Share

Report

Posted on by crham

I've created a Dataflow that imports products from another SQL database.

I'd like to use that Dataflow to also import those products into Price List Items with the Lists proper calculations.

However when I duplicate the query, give it a different name and then try to Load into the same entity as the first query it won't let me with an error.

Does this mean that I have to create a separate Dataflow for each Price List I want to import the Products into?

Of course in SQL I can do a UNION to do this. If the above is not possible, then is it possible to something like a UNION with the Query in the Dataflow?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @crhambrick

Create a KEY in the table,(Unique Key like I'd)

Navigate to https://make.powerapps.com

Click Dataverse then select table

Search for the Respective Table

Click Keys and Add a new Key

This will avoid creating duplicate entry in Dataflows

Was this reply helpful? Yes No
crham 56 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response but maybe I did not word my question well.

I’ve created a data flow to move products over from one SQL database into the 365 product entity. In that same data flow I would like to take those products and create price list items for each of the three price list items we have so effectively in my mind I’m thinking something like a union in SQL because we are repeating the product three times but changing a couple of the settings.

What I first tried was to create three references and then load each into the price list item entity but once I tried the second referenced set it said trying to duplicate entities (I forget the exact error I am not in front of it right now.)

Was this reply helpful? Yes No
Verified answer

crham 56 on at

Like (0)

Report
Copy link

Link copied!

I solved the problem just by creating a view in SQL with some unions and now the data flow pulls them all as one dataset, but was trying to see if I could solve it with a dataflow to keep the logic there, but not gonna waste my time on it now.

Was this reply helpful? Yes No