Unanswered

Missing columns during mapping when importing data from excel

(2) Share

Report

Posted on by 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):

Creation of a new Table with Document Number as primary field.
Creation of a new column WBS Element
Click on "Save Table" button
Select "Get data from Excel"
Upload the document
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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (31)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Hi @YannLS ,

Have you tried publishing the customization?

Thanks,
Bipin

Was this reply helpful? Yes No
YannLS 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
YannLS 10 on at

Like (0)

Report

Posted by mistake

Was this reply helpful? Yes No
YannLS 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@YannLS

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

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

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.

Was this reply helpful? Yes No
carlilelance 351 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
tschopp 311 on at

Like (0)

Report

I'm also having this issue. I imported data once. Then deleted a column and added another. The deleted column continues to show on the import column list and the new one doesn't. I tried publishing all customizations and manually adding a first row of data. Still having the issue. Anyone find out how to clear the cached column list?

Was this reply helpful? Yes No