Copy a record from one Dataverse table to another when both tables have the same structure

(0) Share

Report

Posted on by Hanfried

Hello,

I have a question.

I have two Dataverse tables (ACProjekte and ACProjekte_A1) that are structured in exactly the same way, i.e. they both have the same columns.

As the ACProjekte table can become very large, I would like to move some of the data records from ACProjekte to ACProjekte_A1 from time to time.

As my tables have a lot of columns, I don't want to use the Patch or ForAll function, as I would then have to specify each individual column.

I found the following solution on the Internet:

ClearCollect(col_ACProject_A1;Filter(ACProjects;ACProjectKB=ThisItem.ACProjectKB));;
Collect(ACProjects_A1;col_ACProject_A1)

Unfortunately this does not work! Is there a simple solution to copy a dataset from one dataverse table to another dataverse table if they have the identical structure?

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Jonathan Manrique 2,687 on at

Like (0)

Report

Re: Copy a record from one Dataverse table to another when both tables have the same structure

Hi @Hanfried

You can use Power Automate and call it with a button that way every time you press the button the data from your table will be copied to table b.
When using canvas app you would have to do it using this method, the other way is to write a plugin in C#

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution
Follow me on Linkedin, I talk about Power Platform
www.linkedin.com/in/jonathan-manrique-rios

Was this reply helpful? Yes No