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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup column within D...
Power Apps
Answered

Lookup column within Dataverse migraton of data using DataFlows

(0) ShareShare
ReportReport
Posted on by 32

I am having horrible problems with trying to get a lookup column migrated with the Dataflow Tool. 

 

What my request should be surprisingly quite simple.

 

I have a table 'call it table 1' and i have a table called table 2 which is am trying to migrate the data. 

 

There is a lookup column in table 2 which is linked to table 1. 

 

and i am trying to get the value of it within a column in table 1. 

 

I have used a key to get the column in dataverse like this  - imagine this is table 2 

 

JasonHoffoLeic_0-1672331849182.png

as the column i am looking to get is UWDepartment - and it is linked to a column called LOB in Table 1 and when i try and link the columns together - i get this in DATAFLOW : 

 

JasonHoffoLeic_1-1672332007309.png

so it seems that my key has worked cos the destination is the UWDepartment key as per my above key screenshot .

All i get in the source is : 

 

JasonHoffoLeic_2-1672332122020.png

This gives me loads of errors saying the GUID does not exist but it does.. 

 

""avg_CarrierLOB@odata.bind"": ""/avg_uwdepartmentses(avg_uwdepartment='04f546cb-224e-ed11-bba2-0022481b5772')""
}","{""error"":{""code"":""0x80060891"",""message"":""A record with the specified key values does not exist in avg_uwdepartments entity""}}"

 

I am passed banging my head against the wall now with this... anyone can help would be much appreciated. 

 

 

 

I have the same question (0)
  • Verified answer
    JasonHoffoLeic Profile Picture
    32 on at

    I have fixed this by using this column instead : 

     

    JasonHoffoLeic_0-1672332683809.png

    so i found the one below which had name on the end and it seemed to have worked... This should be easier...

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard