cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Custom columns not appearing import mapping

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

365-Assist_0-1605234287750.png

 

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.

 

365-Assist_1-1605234393705.png

Note- It is a valid colum in the Table.

 

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

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

1.JPG

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:

Best Regards,

Bof

Highlighted
Community Support
Community Support

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

Highlighted

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.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Users online (2,439)