cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenGin
Advocate I
Advocate I

Dataflow - Destination column not present for LookUp Field created from a Relationship

I need some help with populating Dataverse Tables using Dataflow.

I have a main Dataverse Table (Problem Solve Problems) that has One-To-Many Relationships with 3 other tables (Notes, Personnel, Whys). These relationships were created at the main table "Problems" using the "Add relationship" button.
I have a Power App where users will create a new Problem into the main Problem Solve Problems table.
Each of these Problems can then have multiple Notes, Personnel, and Whys.

 

BenGin_0-1637722138724.png

 

I want to be able to add data from CSV files (e.g. CSV exported from the Dataverse tables so I can populate the tables in another environment - create in Dev, add into Production).

But in the DataFlow, not all the columns are available to map into (Destination columns for the relationship are not available for example in the "Notes" table).

BenGin_1-1637722261037.png

 

The lookup column for the relationship exists in the CSV file and appears in the 'Source column" options, but I have no "Destination column" to map it into.

Same goes for that I cannot find the "Destination column" in the main "Problems" table for the Uniuqe ID column that should match with the Relationship column name in the "Notes" table.

 

I tried creating a key in the "Notes" Table, but it is still not showing in the DataFlow "Destination column".

BenGin_2-1637722304359.png

 

I also cannot find the matching auto generated Unique Id for the Lookup Relationship column to create the Key in the main Problems table.

That is the only column that will be the same in the "Problems" and "Notes" tables.


If I manually Import Excel file, then the automapping shows all the Table columns including the relationship column.

BenGin_3-1637722333978.png

 

BenGin_4-1637722339283.png

But the problem is if I have DateTime columns. I keep getting errors with the data formats, and the data will fail to import.

Dataflow allowed me to use Power Query to sort out the DateTime columns, plus make it easier to execute on demand.

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,104)