Hi lovely community,
currently I'm wondering how to copy about 55K Records incl. 120 columns (about 20 lookup columns) from one table 1:1 to another table? This is just one time per year to have kind of "Snpashot".
Just archiving or exporting records to file is not an option. We need it as the same table.
I already have cloned the table via XRMTool. Have set up Power Automate (connected with Power Apps) to trigger copying of one year.
Unfortunately there's the following limit (aready have splitted requests in 12 months):
Do you know a faster and more stable way to copy records from one table to another table in dataverse?
Unfortunately I can't use Dataflows cause there are some lookup columns and their tables behind without data integration key (and it wouldn't make sense here to create one).
BR,
Sven
