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?


Report
All responses (
Answers (