Import Leads does not work with dropdown field values, only labels (keys)

Hello Ishani Vardhan, 

I was double-checking on my end and Sugar will allow you to import records with either the Key value OR the Label value of the dropdown. 
Can you provide an example of the record you are trying to import and the correspondent Dropdown value so we can check if something else is at play here? 

Thanks for your response Andre Serrazina !  For me, the key doesn't work.

I had just 1 record for testing import with the key or the bold part from above screenshot in the field. However, the import process throws error like the below for all dropdown fields.

"Value not in dropDown list. Allowed values are:Submitted,Withdrawn,Pending,Not Completed,New Expression of Interest Administration Status (administration_status_c) administration_status_c"

This means, I'd have to heavily edit my CSV to change all keys to label values which would be an extremely tedious job when its hundreds of records to import.

Is there a setting I'm missing?

Thanks for your response Andre Serrazina !  For me, the key doesn't work.

I had just 1 record for testing import with the key or the bold part from above screenshot in the field. However, the import process throws error like the below for all dropdown fields.

"Value not in dropDown list. Allowed values are:Submitted,Withdrawn,Pending,Not Completed,New Expression of Interest Administration Status (administration_status_c) administration_status_c"

This means, I'd have to heavily edit my CSV to change all keys to label values which would be an extremely tedious job when its hundreds of records to import.

Is there a setting I'm missing?

Hello Ishani Vardhan, 


Thanks for the extra detail. 
I've created a similar dropdown on a stock installation and managed to perform the import correctly. 

I could reproduce the error that you see, but that is because Sugar was trying to import the header of the file. 
That is prevented by checking the following option: 

Can you double-check if that is the scenario that you are facing? 
I created a video of my scenario with a short explanation I hope this helps: 

https://www.screencast.com/t/pZYzBOPrwLCU


André