Hi: I have 2 entities in CDS, "Companies" & "Countries".
Companies has a look-up relation with Countries, so in Companies I have a field, CountryID, pointing to Countries entity.
The Countries entity is fully loaded and operational in CDS.
I prepared an Excel template with two rows only for the Companies entity which I filled with name and a CountryID value (which I took from an export of Countries entity).
When I try to import it to Companies entity I get an error, saying that there ís no recorcd in Countries entity matching what I put in CountryID.
ROWNUMBER EXECUTIONID ERRORCOLUMN ERRORCODE ENTITYNAME DEFINITIONGROUP ERRORDESCRIPTION 1 ImportService_2018_05_22T20_30_14_207Z-2018-05-22T20:31:14-C438751F2D634A28B39DAC50BE97789 DMF1959 tblXpreXCompanies_ ImportService_2018_05_22T20_30_14_207Z The source file has duplicate values specified for unique field(s). 2 ImportService_2018_05_22T20_30_14_207Z-2018-05-22T20:31:14-C438751F2D634A28B39DAC50BE97789 DMF1959 tblXpreXCompanies_ ImportService_2018_05_22T20_30_14_207Z The source file has duplicate values specified for unique field(s).
I tried different ways of doing the import, getting always a similar error.
Any advice on how to fix it will be much appreciated.
With my BRGRDS / JLB.
Whats the key you are using to ensure uniqueness? Is there a Primary and/or alternate keys defined for your tables? Have you defined any keys under "Keys" for Countries table?
Hi Sabine: Thanks a lot for your quick response.
I used the PrimaryId in the child table, no other key has been defined.
Below printouts for entity Companies, fields and relations definitions plus a printout of entity Countries field definition.
Please let me know should you need any other information.
Thanks again / JLB.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Check out the new Power Platform Community Connections gallery!