Dataflow | Lookup field as one field of alternate key | Null values

(0) Share

Report

Posted on by KSven

182

Hi lovely community,

Ive built an dataflow with an alternate key for integration. I already know how to use look up fields as part of my key and how to set up the integration key in admin portal.

My key is like this:

Quarterdate

Salesman (Contact Lookup)

Dealer (Account Lookup)

It works if theres content in all 3 fields. But if there's one record with "null" content in one of the lookup fields there's the following error message:

So all fields of alternate keys have to has content and can't be null?!

If its not an required field in table, how I can have an empty integration for it?

BR,

Sven

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

KSven 182 on at

Like (0)

Report
Copy link

Link copied!

No ideas...? 😕

Was this reply helpful? Yes No
Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @KSven

When you are setting the lookup to ‘Null’ what is the input data? Is it blank or are you trying to import a value of Null? Are you able to share a screenshot of your Power Query transformation page?

Was this reply helpful? Yes No
KSven 182 on at

Like (0)

Report
Copy link

Link copied!

Hi @HSheild ,

have tested it with a Test table.
1. Test (alternate Key with 2 normal columns, Name + district )

Name Column (Primary Column of table) district (text column)
"Test1" "A-District"
"Test2" null
--> Data Integration works fine

2. Test (instead of district column as text, its now a lookup to table "district")
District has alternate key of "ID" (Text Column) and "Validtill" (Date Column) -> Works great in other LookUp columns without beeing alternate key

Name Column (Primary Column of table) district ID (part of lookup column) Valditill (part of lookup column)
"Test1" "54" "2021-01-06"
"Test2" null null

--> In this case there will be the error message "lookup value was not found"

Regarding to you question, in my query nothing is blank(), all empty columns are null.

BR,
Sven

Was this reply helpful? Yes No
Ostritch 20 on at

Like (0)

Report
Copy link

Link copied!

Facing same issue, any updates on this?

Was this reply helpful? Yes No