Power Platform Community Forum Thread Details

Excel import overwrites data when using lookup and number column in composite key constraint

Hi there,

I have two tables in Dataverse as below

Clients table with the following columns

Name (Text, Primary Column)
Identifier (Number)

Products table with the following columns

Name (Text, Primary Column)
Client (Lookup, Clients table)
Identifier (Number)

I have created a key on the Products table which includes both the Client and Identifier columns. The intention of the key is to place a unique constraint which includes both the Client and Identifier. This is because Client A could have a Product with Identifier 123 and Client B could also have product with Identifier 123.

Scenario

Given an existing row in the Product table with Client A and Identifier 123

When I perform a data import using the Import data from Excel button

And the excel file contains a row with Client B and Identifier 123

Then the excel import completes without errors

And the existing Product row will have the Client column updated to Client B

Any ideas on how I can solve this issue?

Regards,
Jqueen2

Categories:

Microsoft Dataverse

Quick Links

Subscribe to this forum!