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,580 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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