Unanswered

Import data from Excel- New Columns in Table are not recognized

(9) Share

Report

Posted on by Community Power Pla...

Hi Community,

Adding for the benefit of community- we have a solution in Prod environment that went into Dev a couple of weeks back. During Dev, we added some columns to the Dataverse Tables as an update to the solution. When we imported the solution back to Prod, we had to update the existing data in the Table. We downloaded the data, imported the solution which added columns to the Table, removed all the data from the Dataverse, updated the data in excel and tried importing the data back into the Dataverse table.

Now while Importing the data using Get data from Excel option, the system did not recognize the newly added columns despite publishing customizations and a 100 or so refreshes.

What worked was- and I might be completely off the rocker here but so is Power Platform- I exported the data from the tables (which were blank btw), and by some miracle the Get data from Excel also starts recognizing those columns.

Hoping that this will save some painful rework for others!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

BradFromOz 3 on at

Like (0)

Report

This solution is 100% viable. Thanks HimanshuSSharma.
My situation involved a custom table within a solution.
I had updated the table to delete 3 columns and add 1 column.
When I then went to import data via Excel spreadsheet, the deleted columns continued to show and the added column did not.
I had tried multiple solutions. Publishing the table, logging out, clearing cache, different browser....yet none solved this issue.
I did also try Edit Data In Excel, which showed the updated table, yet did not create any change in the import fields.
Only when I found this solution, was I able to resolve this issue and have the new import fields appear and solve this Dataverse Excel import problem.
Hoping this contribution can also help save some time for others also.

Was this reply helpful? Yes No
AlexinEdmonton 43 on at

Like (0)

Report

I was starting to think I was crazy until I saw this solution which worked instantly. Not sure why the system works this way, but like you said the Power Platform does not make sense a lot of the time. Thank you for this, it no doubt saved me work trying to figure things out myself.

Was this reply helpful? Yes No
TSGSJeremy 3 on at

Like (0)

Report

Two years later and this is still a problem. Your solution still works, but the first time trying to export I got an error that one of the columns I'd deleted didn't exist. Who says Microsoft isn't on the ball? Second time I exported it succeeded. So just keep trying to export till it succeeds (as is tradition with Power Platform) and then you can import.

Was this reply helpful? Yes No
AlfonsoPC 3 on at

Like (0)

Report

Works as charm!
First, I was battling with some deleted column that appeared as required when importing data.
Then I recreated the table, made a quick test, everything went fine, but when added the remaining columns those did not appear on the list. This quick trick solves the issue.

Thanks, mate, you saved my mental health!

Was this reply helpful? Yes No
maggmuf 3 on at

Like (0)

Report

Saved my sanity... Recreated the table multiply times and the import mapping was still stuck...
Thank you!!!

Was this reply helpful? Yes No
gillsantos 3 on at

Like (0)

Report

Worked like a charm. I pray for thee, oh dear anonymous hero.
Thank you for sharing 😃

Was this reply helpful? Yes No