cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mkekovic
Level: Powered On

CRM fields not showing up when mapping

Hello everyone,

 

In order to create new fields I go in the solution explorer and expand the certain entity and choose the fields node and create a new field. After this if I am trying to import the excel spreadsheet, and map the fields, the new field doesn't show up. Does anyone know what is going on?

1 ACCEPTED SOLUTION

Accepted Solutions
SKH19
Level 10

Re: CRM fields not showing up when mapping

Data import can be a huge pain, but I find it works a lot better if you use the old data import wizard.

First take the file you want to import and convert it to CSV by selecting the file type when saving it in excel:

Annotation 2019-12-12 144725.png

 

Then, from Power Apps, select the gear in the top right corner and select Power Platform Admin Center. In the admin center, select your environment and hit Settings. From there you can get into the data import wizard:

 

Annotation 2019-12-12 144544.png

 

Select IMPORT DATA and choose your CSV file, then follow the wizard. This works out much better and doesn't have any of the errors you see when trying to import using the new Power Platform model.

 

View solution in original post

5 REPLIES 5
PowerBack19
Level 8

Re: CRM fields not showing up when mapping

After you created the field, did you click the "Publish Customizations" button at the top? 

 

Also, I would recommend downloading a new Excel template from this entity. This should contain the newly added field.

 

Lastly, if you are using the Excel template, then field mapping is unnecessary. It should auto map the fields and allow you to import the data. 

mkekovic
Level: Powered On

Re: CRM fields not showing up when mapping

Hello,

 

1. Yes I would save changes and publish the customizations for that entity. The field shows up under the node "Fields", but not if I try to map it by "Get data from Excel".

 

2. I have tried downloading the template. The field is in the template, but when I try to import it, only 30% of my fields are mapped and the field that I created previously is not there to map to. 

SKH19
Level 10

Re: CRM fields not showing up when mapping

Data import can be a huge pain, but I find it works a lot better if you use the old data import wizard.

First take the file you want to import and convert it to CSV by selecting the file type when saving it in excel:

Annotation 2019-12-12 144725.png

 

Then, from Power Apps, select the gear in the top right corner and select Power Platform Admin Center. In the admin center, select your environment and hit Settings. From there you can get into the data import wizard:

 

Annotation 2019-12-12 144544.png

 

Select IMPORT DATA and choose your CSV file, then follow the wizard. This works out much better and doesn't have any of the errors you see when trying to import using the new Power Platform model.

 

View solution in original post

mkekovic
Level: Powered On

Re: CRM fields not showing up when mapping

Perfect! I could see my fields there. Thank you very much!

SKH19
Level 10

Re: CRM fields not showing up when mapping

@mkekovic 

No problem, I spent a lot of time on this myself!

 

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,783)