Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

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

(0) ShareShare
ReportReport
Posted on by 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:
  • Verified answer
    Re: Deleted a required column, still showing up during data import in mapping

    Thank you so much @dpoggemann ! I was doing this a much more complicated way so this will save me so much time! 

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

    Hi @Anonymous 

    You fill in the primary name field from your lookups... Should be same as what you were doing otherwise...  


    Thanks,

    Drew

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

    Thank you @dpoggemann  for taking the time to try to help. I don't think I can import this way as I have so many look up columns that I have to add the GUID for so have the excel file using Power Bi. I can't figure out how to add look ups using the template option. 

     

    I'll raise a ticket. 

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

    Hi @Anonymous ,

     

    Got it.  This might be a bug, not sure...  You may want to open a case on this one.

     

    I would do the following and see if it gives you a better solution, this is the import approach from Excel that I utilize.  

    1.  Go to https://admin.powerplatform.com 

    2.  Go to environments and click on your environment

    3.  Top of screen chose "Settings" for the environment

    4.  Choose "Templates" -> "Data Import Templates" 

    5.  Select your "Entity" and this will provide you a download Excel template

    6.  You can then import on the "Data Management" area under Settings

     

    Hope this helps.


    Thanks!

    Drew

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

    I go into the solution, then into my table, I select data and import from excel. 

    When I come to map the columns, lots are showing as required which have now been changed to optional in the table and show as optional in the app so have been published. This is in the Dev environment but the same in Test too. 

     

     

    import dataverse.JPG

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

    Hi @Anonymous 

     

    Please help me understand what you mean on the "Import Screen".  There are multiple options here and want to know what you are referring to.

     

    Thanks,

    Drew

  • 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? 

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,273 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 

  • 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? 

     

  • 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?

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics