web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataflow issue: data i...
Power Apps
Answered

Dataflow issue: data insertion order

(0) ShareShare
ReportReport
Posted on by 12

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

I have the same question (0)
  • Verified answer
    lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at

    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.

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard