Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

primary name field not populated

I have uploaded data from excel into an entity, but it hasn't auto-populated the primary name fields. Although this is a required field, CDS for Apps has still accepted the upload.

How to I get it to generate this field when details are uploaded in the first instance?

Community Support
Community Support

Re: primary name field not populated

HI @Caroline ,

Could you please share a bit more about your scenario?

How do you upload data from your Excel table to an CDS Entity?

Further, do you perform Primary Name field mapping when you import data from your Excel into your Entity?


I have made a test on my side, and don't have the issue that you mentioned. If I do not specify a column value from my Excel for the Primary Name field, when I perform "import", the following error would show up:

"The Primary Name field is a Required field"

In addition, you could also considert take a try with the "Open in Excel" functionality within CDS Entity to import your data from your Excel instead of "Get data from excel" option.

More details about the "Open in Excel" functionality in CDS Entity, please check the following article or blog:


Also please consider take a try with the alternative solution mentioned within the following thread:


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resolver I
Resolver I

Re: primary name field not populated

Hi @v-xida-msft 

Initially, I imported from excel, but it didn't import the data types, instead it set everything as text fields.

I then opened the entity in excel and populated the table using the excel add-in. That resolved the data type issue, but didn't populate the primary name field. This has happened in 5 seperate entities.


Opening in excel also seems to have an odd quirk if it hits an error, which it didn't do in the previous verson. It will highlight the row that's in error, as expected, but delete any new data that comes after the row, and re-order the data that was uploaded before it hit the error, so it's difficult to identify what data needs to be re-entered. If anyone has any ideas on that too, I'd be grateful!


I will try the PowerQuery option shortly...

Resolver I
Resolver I

Re: primary name field not populated

@v-xida-msft Sorry I didn't get back to you on this one. It seems that I needed to set it to Autonumber, another change that I wasn't aware of since the upgrade.

However, this has now manifested another problem. It will autogenerate the Primary Name when I use the excel add-in, but not when adding a new record from the app itself.

Helpful resources


New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (3,971)