
Announcements
Hi, I'm asking for your help with a problem I'm currently having with dataflow.
To summarise, I have created a dataflow in order to import data from two CSV files into a Dataverse table.
In this Dataverse table, I have a lookup field representing a link to the direct parent of this record.
The steps I've taken:
Creation of a key object linked to my primary ID field
Merge (Left outer join) the two data sources to retrieve a particular field
Match the fields from my "Merge" table with the fields from the Dataverse table.
My problem is as follows:
When I run the dataflow to import the data, the flow stops because when I fill in a lookup field, it doesn't find the corresponding value to bind as it doesn't yet exist in the table.
I've tried filtering the data so that the import can proceed without any integrity problems, but the problem persists.
The insertion doesn't seem to be done in the order of the dataset rows.
Do you have any idea why? And do you have a solution?
Thanks in advance
You cannot reference data that you are currently writing into Power Query. You can do self referencing, but only with data you have written into the dataflow previously.