You’re offline. This is a read only version of the page.
Hi there,
I have two tables in Dataverse as below
Clients table with the following columns
Products table with the following columns
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
Hello, @Jqueen2, you will have to use the Name and Identifier in the Clients table as Alternate Key. Create Alternate Key in the Clients Table and Select both Columns. Make sure you select the alternate key when mapping the Excel columns in the Dataflow.
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
Share
Report
All responses (
Answers (
6,680
