Missing columns during mapping when importing data from excel

[YannLS]

Hi,

I am trying to "Get data from Excel" in the Power Apps website throught the Dataverse/Table page, but some columns are not visible during the mapping sequence. Here the sequence that I do (simplified version, but doesn't work either ways):

1. Creation of a new Table with Document Number as primary field.
2. Creation of a new column WBS Element
3. Click on "Save Table" button
4. Select "Get data from Excel"
5. Upload the document
6. Click on "Map columns" button

Result: In the left columns, the Document Number field is listed but not the WBS Element field, so it cannot be mapped to anything in the Excel file. I choose the "All columns" filter to be sure to not miss anything, but still doesn't show my WBS Element field.

Picture of the Table columns and the "map columns" view.

Am I missing any steps there or is it actually a bug in the interface?

[Mira_Ghaly]

@YannLS 

I have tried to reproduce the same and the column appeared , I would suggest deleting the column and adding it again and retry the action

[bipinshan]

Hi @YannLS ,

Have you tried publishing the customization?

Thanks,

Bipin

[YannLS]

Hi @bipinshan ,

From the new interface of Power Apps, should not "Save Table" button publish it automatycally?

If it is not the case, could you explain me a little bit more how to publish it from the Power Apps interface please?

Thank's,

Yann

[YannLS]

Posted by mistake

[YannLS]

Hi @Mira_Ghaly ,

I tried to delete the column and recreate it. I also delete the table and recreate it from scratch and nothing works. When you are doing the steps that I listed above, you did nothing more then that and only that because I don't do anything more on my side? Here 2 more screenshots of the creation steps for the table and the new field if it could help explaining what I am doing wrong:

All other fields (checkboxes) has been uncheck.

Hope something there could help you find what I am doing wrong.

Thank's for the help,

Yann

[Mira_Ghaly]

@YannLS 

yes i have applied same exact steps as you mentioned, Try Republishing, this is how you can do this from the new interface

[bipinshan]

Hi @YannLS ,

You need to click on Solution from left navigation then click on Publish Customization button from top bar as shown in below image -

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: https://xrmdynamicscrm.wordpress.com/

[N3WT0N]

So experimented a bit. The problem seems caching. The moment you click import form Excel all column names are cached. From now on you will be presented with always the same columns doesn't matter if you add or delete some. I haven't found a way to reset the cache. The only thing you can do is create a completely new table with a different name.

[carlilelance]

I, too, had this issue, but when I manually enter in the first row with data, then do the import, the columns now appear as expected. Try this.