You’re offline. This is a read only version of the page.
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?
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
Share
Report
All responses (
Answers (
2,687
