Custom columns not appearing import mapping

[365-Assist]

I have created a custom field "Occupation" into the standard CDS Contact Table.

and now am tying to import data from an excel (CDS templated) sheet. However I have been given a warning by the import procedure that The following source file columns have not been mapped to Contact fields: Occupation

When I search for the CDS Column in the mapping sheet "Occupation" does NOT exist.

Note- It is a valid colum in the Table.

How can I mapp this field when the import mapping procedure cannot see it?

[v-bofeng-msft]

Hi @365-Assist :

Could you tell me:

• Are you using power query to import data?

I made a similar test but did not encountered the problem.I suggest you:

1\Do not forget to save the entity after add a new field

2\Please use the Name of the field instead of DisplayName.

On your side ,it should be "cr522_Occupation" instead of "Occupation"

In addition, you can also try:

• Add a field again
  
• Clear browser cache
  
• create a support ticket

Best Regards,

Bof

[v-bofeng-msft]

Hi  @365-Assist :
Has the problem been solved?
Is there anything else I can help?
If this post helps, then please consider Accept it as the solution to help others.Thanks
Best Regards,
Bof

[365-Assist · Accepted solution]

Hi @v-bofeng-msft 

thanks for your reply. I seem to be able to fix it a few days later after I recreated the table.

[ghosharitrakr]

I too faced this issue. Wonder if there is any fix. Seems like the missing fields only appear after you recreate the table.

In my case, the first set of fields created at the beginning when the table was created and saved always appear in column mappings. The ones which are created later never appear. This is really ridiculous. I think this is a product bug and needs to be fixed.

[____]

I found this post describes the best work around by using the Power Platform Admin Center to import from Excel, this way all new columns will appear in the mapping section:  Solved: CRM fields not showing up when mapping - Power Platform Community (microsoft.com)

[reh5]

You need to Publish all customizations after adding additional columns to a table.