Custom Columns?

[JohnStraumannPA]

Hi all: I created a new Dataverse table called "Company", with 2 custom columns, Name (text) and Id (Whole Number). I have an Excel Spreadsheet with 100 records, and when I try to import into Dataverse, for some reason the ID column does not show up. I thought maybe the name was the problem as a reserved word or something, so I tried a name of Cid, but no luck. I also tried creating a new column of type Text, but that didn't work either. I tried publishing all customizations, a Browser refresh, restart, etc., Can anyone make a suggestion?

[v-xiaochen-msft · Accepted solution]

Hi @JohnStraumannPA ,

There are the following possibilities:

1\ Delay or caching issues

2\ column name caused 

You could try to create a column in your excel file. Its column name is the custom column name in dataverse.

// In my test I fixed the problem by modifying the column name in excel.

But I can't be sure that the problem is caused by the column name, it could be the delay.

Besides, you could use a easier way to do it. (I prefer this method.)

Best Regards,

Wearsky