Answered

Deleted a required column, still showing up during data import in mapping

(0) Share

Report

Posted on by ColdSpark

Hi Everyone,

I deleted a required column from a table. Now when i go to import data to that table the deleted column is still showing up as required in the data mapping interface. Anyone know how to clean this up?

Thanks!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (16)

Answers (2)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @ColdSpark,
If you delete the column and publish the solution the column will be removed from the data import template if you download a new template. Where are you seeing the column when you say the "data mapping interface"? Is this the data import wizard and are you utilizing a map that you had saved in the past? If so, I would suggest creating a new map.

Hope this helps, let me know if I am missing what you are asking... If this did solve, please mark accepted. If it helps somewhat then please like if possible.

Thanks!

Drew

Was this reply helpful? Yes No
ColdSpark 28 on at

Like (0)

Report

I am referring to the data mapping interface that comes up after you select Data > Get Data > Get Data from Excel, and then upload a csv. It is always still showing the deleted column that i have confirmed is gone when you go look at columns.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @ColdSpark,

I walked through this process with a custom table and did the following steps and the column I deleted no longer appeared, can you try and verify?
1. I removed the column from all forms / views / business rules / controls etc.
2. I deleted the field from the Table in the dataverse
3. I navigated to Solutions in the make.powerapps.com and I chose to "Publish All Customizations"
4. I went to the table again and chose the Data --> Get Data --> Get Data From Excel
5. The field no longer existed in the dataverse side to map to. Of course I still had in my Excel file but no field to map to in the dataverse.

If the steps above do not work, can you try clearing cache in your browser? I am using Chrome...

Thanks,

Drew

Was this reply helpful? Yes No
ColdSpark 28 on at

Like (0)

Report

Unfortunately I have done all of these things. I have published all customizations and cleared cache in chrome. The field is still showing.

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @ColdSpark,

I would verify the following:
1. Show "All fields" in your view of fields to really verify it is gone 🙂
2. Verify your environment to make sure you didn't delete from Dev and you are in Prod or something like that.

If both of these above are not the case then Open a case with Microsoft as something is not right.

Thanks much,

Drew

Was this reply helpful? Yes No
ColdSpark 28 on at

Like (0)

Report

Yup, both done and have opened a case. Thanks!

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

Like (0)

Report

I am having the exact same issue. can someone redirect me to the case so I can view resolution there?

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

Like (0)

Report

I have the same issue with columns showing as required but these have been changed to optional. The changes are not updating. @ColdSpark did you find a solution?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Please make sure you "Publish All Customizations" and this should resolve.

Thanks,

Drew

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

Like (0)

Report

Thanks for the response @dpoggemann I have published all Customisations and the changes show in my App fine. It is just on the import screen that they are still showing as required.
Any other suggestions? I've cleared my cache and logged out?

Was this reply helpful? Yes No