Solved: Re: Duplicate dataverse table

knyklu · ‎01-01-2024

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

gcmfaizan · ‎01-01-2024

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:

Select your table e.g I select Commercial Data Workflow
Then Click on the Export Button from the header, and from this Select Export Data.
It's prepared a zip file for you containing all column names and Data Rows.
Unzip the downloaded from your download folder.
Come back to your environment select New Table from the Header and click on Upload an Excel File.
Select the Excel file from your Unziped folder and wait for seconds.
After a few seconds, you see the auto-created table with column name and it also contains all records as per the Excel file.
Change the Table name by clicking Edit Table Properties from the header and press Save button.
Cross-check the Column name and its data type, once you are done click on the Create Button from the lower right corner.
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!

View solution in original post

gcmfaizan · ‎01-01-2024

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:

Select your table e.g I select Commercial Data Workflow
Then Click on the Export Button from the header, and from this Select Export Data.
It's prepared a zip file for you containing all column names and Data Rows.
Unzip the downloaded from your download folder.
Come back to your environment select New Table from the Header and click on Upload an Excel File.
Select the Excel file from your Unziped folder and wait for seconds.
After a few seconds, you see the auto-created table with column name and it also contains all records as per the Excel file.
Change the Table name by clicking Edit Table Properties from the header and press Save button.
Cross-check the Column name and its data type, once you are done click on the Create Button from the lower right corner.
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!

zabronm · ‎04-04-2024

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...