Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Copy table from one env to another

(0) ShareShare
ReportReport
Posted on by 26

Hi,

 

we have an app in prod. The app works with a lot of tables we have. 

When we created a sandbox/dev environment and copied the app to the new environment, all the tables are missing.

 

I was trying to export a table from production and import it to the dev env. It works but the schema name is not the same as original. For example the column name in production is ddr33_name but in the new environment it is 4rgcc_ddr33_name.

 

Is it possible to just get a identical copy of a table in another environment?

 

I was also looking into solutions, would this be the right approach?

 

Thank you in advance!

Categories:
  • Stas_Magid Profile Picture
    2 on at
    Re: Copy table from one env to another

    Hi,

     

    But if I export a table and import it to a new environment, won't it be assigned a new prefix to its name (according to the default environment publisher) so the migrated app will not recognize this table?

  • mcsd Profile Picture
    2 on at
    Re: Copy table from one env to another

    I recommend using a DataFlow to copy your table data from one environment to another.  You can then set up the Dataflow to copy the data on a schedule or on a manual refresh.

  • Verified answer
    365-Assist Profile Picture
    2,312 Super User 2025 Season 1 on at
    Re: Copy table from one env to another

    You did nothing wrong. The data does not come across with solutions. 

    If you want to migrate the data you will need to export the table data to xls/csv and import them into the new environment one table at a time.

    --------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

  • VBuki Profile Picture
    26 on at
    Re: Copy table from one env to another

    Ok so I created an unmanaged solution with all the tables needed. I have all the tables in the new environment but the tables are all empty. What did I do wrong? 🤔

  • VBuki Profile Picture
    26 on at
    Re: Copy table from one env to another

    Thank you! And just to make sure, with the Solution I am creating a copy and don't move actually something from one environment to another?

     I found this link > Power Apps Guide - Dataverse - how to access tables from another environment - Power Apps Guide - Blog

     

    But it is not clear when switching from one environment to another and getting tables, are we copying them or we just use the same table just in different environments?

     

    Thank you again for your fast reply, I really appreciate it!

  • Verified answer
    365-Assist Profile Picture
    2,312 Super User 2025 Season 1 on at
    Re: Copy table from one env to another

    Yes you can only do this using an Unamanged Solution. Her is some Documentation that explains how to use Soltuons. Solution concepts - Power Platform | Microsoft Learn

     

    --------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics