web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Deleted a required col...
Power Apps - Microsoft Dataverse
Answered

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

(0) ShareShare
ReportReport
Posted on by ColdSpark 28

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
I have the same question (0)
  • Drew Poggemann Profile Picture
    Drew Poggemann 9,283 Most Valuable Professional on at
    Re: Deleted a required column, still showing up during data import in mapping

    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

  • ColdSpark Profile Picture
    ColdSpark 28 on at
    Re: Deleted a required column, still showing up during data import in mapping

    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.

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,283 Most Valuable Professional on at
    Re: Deleted a required column, still showing up during data import in mapping

    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

  • ColdSpark Profile Picture
    ColdSpark 28 on at
    Re: Deleted a required column, still showing up during data import in mapping

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

  • Verified answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,283 Most Valuable Professional on at
    Re: Deleted a required column, still showing up during data import in mapping

    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 

  • ColdSpark Profile Picture
    ColdSpark 28 on at
    Re: Deleted a required column, still showing up during data import in mapping

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

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Deleted a required column, still showing up during data import in mapping

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

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Deleted a required column, still showing up during data import in mapping

    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? 

     

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,283 Most Valuable Professional on at
    Re: Deleted a required column, still showing up during data import in mapping

    Hi @Anonymous

     

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

     

    Thanks,


    Drew 

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Deleted a required column, still showing up during data import in mapping

    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? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans