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 : LXy2mJVEauTSGUf/RiDe/p
Power Apps - Building Power Apps
Answered

Duplicate dataverse table

Like (0) ShareShare
ReportReport
Posted on 1 Jan 2024 16:34:17 by 149

Hi,

What is the easiest way to make copy of whole table (structure and data). I'm going to make an 'archive' for my main dataverse table. There is ca. 35 columns and each day ca. 200 records are added.
I know, I can do it manualy but is there any ctrl+c / ctrl+v method?
Each day, with a flow, I want to move  records older than 7 days to 'archive' table.

For regular use (requesting data 100-150 times per hour) I need data from last 7 days. Rest I just need for some statistic works so there is no need to work with all records.

 

Best Regards,

Krzysiek

Categories:
  • Redtree Profile Picture
    2 on 16 Jul 2024 at 17:12:20
    Re: Duplicate dataverse table

    Great. But how about Tables with 100.000 Entries and more. Any experience how to handle this task?

  • zabronm Profile Picture
    23 on 04 Apr 2024 at 16:20:42
    Re: Duplicate dataverse table

    The said options "5. select New Table" are not appearing in my environment . Could I be missing something? 

     

    There is an option under Table options(...): Table =>Table options(...) => Tools =>Copy schema name. I assumed this must be related to duplicating a table schema.. However, I am not sure of what to do next after that. 

     

    Can anyone please assist...

  • Verified answer
    gcmfaizan Profile Picture
    1,022 on 01 Jan 2024 at 17:03:57
    Re: Duplicate dataverse table

    Hi @knyklu ,

    You can create the table in the same environment with the same name but a different schema name. To do this you have to follow bellow steps:

    1. Select your table e.g I select Commercial Data Workflow
    2. Then Click on the Export Button from the header, and from this Select Export Data.
      gcmfaizan_1-1704127931085.png
    3. It's prepared a zip file for you containing all column names and Data Rows.
      gcmfaizan_2-1704128063561.png
    4. Unzip the downloaded from your download folder.
    5. Come back to your environment select New Table from the Header and click on Upload an Excel File.
      gcmfaizan_3-1704128208887.png
    6. Select the Excel file from your Unziped folder and wait for seconds.
    7. After a few seconds, you see the auto-created table with column name and it also contains all records as per the Excel file. 
    8. Change the Table name by clicking Edit Table Properties from the header and press Save button.
      gcmfaizan_4-1704128457281.png
    9. Cross-check the Column name and its data type, once you are done click on the Create Button from the lower right corner.
      gcmfaizan_5-1704128583509.png
    10. Now you have a copy of the table with data.

    For other User Power Automate:

    • Use Power Automate (Flow) to create a flow that runs on a schedule (e.g., daily).
    • Add a trigger that initiates the flow at a specified time or interval.
    • Use the "List records" action to get records from your main table based on your criteria (records older than 7 days).
    • Use the "Create a record" action to insert the retrieved records into the archive table.
    • Optionally, use the "Delete a record" action to remove the archived records from the main table.
    •  

    If this is the answer for your question, please mark the post as Solved.
    If this answer helps you in any way, please give it a like.

     

    Thanks!

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete