using PowerApps how to mass update 1% to 10% records in SharePoint list that has 20k+ records in total

143 views Asked by At

from Power Apps, how could I replace few items values on SharePoint list which has 20K+ items? I tried:

updateif(sourcename, a=dd.SelectedText.Value, {a:dd_1.SelectedText.Value})
1

There are 1 answers

8
Arun Vinoth-Precog Tech - MVP On

From your question it sounds like this is not a performance question or functionality ask. If this is for just a one time bulk data update, you can use any ETL package to run the job for batch updates.

You can use Azure data factory, SSIS package, Scribe, SQL job, or console app hitting SP web api. It really depends on the source/destination and skillset of the team.