Error in key for this row; refers to invalid list item

Hi everyone,

" Error in key for this row; refers to invalid list item : Headcount "

I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount'

Even after that, I am getting the same error. Can anyone please help me on this?

Thank you.

Accepted answers

All comments

Alexandru.Rosca

@Saisri8568

Are there multiple list items that are updated through the load and only this one fails?

If so, please make sure you have the item "Headcount" in the original list that is used for the list formatted property. Also check the spelling to be identical in your list and in data source of the import.

Saisri8568

Yes , I have "Headcount" list Item in Original List and also it matches with source (spelling). Even after that, I am getting this error

Alexandru.Rosca

@Saisri8568 would you mind sharing the setup of your import action and numbered list properties? Is it a model or file import? I have tried to replicate the issue but a wrong import mapping won't allow you to proceed in a numbered list import. Still, can you check if it looks similar with below: where "list item name" is the property name we're trying to match.

Saisri8568

This is a replica of original one. The problem is with 'Capital' list Item. It is a model Import.

debapriya

I tried importing such a list and it worked fine, giving that the combinations of properties are all unique, but the list I imported into wasn't a numbered list. Is there any possibility of making it a non-numbered list and then trying this import? Let me know if it works.

Regards

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…