Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Removed column from table, now can't deploy

(0) ShareShare
ReportReport
Posted on by 64

Hi

 

I have three environments: default, development, and production. I used the default environment to create our 'core' data tables, then deploy those to development as a managed solution. And the build our apps in development, eventually deploying everything to production.

 

Today, I added a new table to default, with a lookup to a wrong table. And deployed this to development where I realised the mistake of looking up the wrong table. So, in default, I removed the lookup column, and re-added it (with the same name) to lookup the correct table.

 

But now, when trying to deploy to development, I get this error:

Solution "Data Tables" failed to import: ImportAsHolding failed with exception :EntityRelationship [new_role_Team_new_team] is invalid. The lookup attribute [new_Team] is already associated with an existing relationship.

 

How do I get past this, so that I can deploy the new version to development, and eventually production?

Categories:
  • nksse Profile Picture
    nksse 64 on at
    Re: Removed column from table, now can't deploy

    Thank you @a33ik. That makes sense and it worked.

  • Verified answer
    a33ik Profile Picture
    a33ik 3,304 on at
    Re: Removed column from table, now can't deploy

    Hello,

    Dataverse is confused in such scenarios like deletion/recreation of the column in the same table with the same schema name but with different metadata.

    1. Delete the new column in your default environment.

    2. Export the solution from default as managed, and import it to development, so deletion will take place there as well.

    3. Create a new relationship/column in default and add it to the solution.

    4. Export the solution from default as managed, and import it to development.

    Now, after that multistep sequence, everything should start working.

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics