Power Platform Community Forum Thread Details

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

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 :

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 :

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.

Categories:

Microsoft Dataverse with Power Apps