Hi!
I think updating (complete, regularly) a SP List from a CSV or Excel File is a very common use case and I am astonished that in 2021 it's still a quite cumbersome job to accomplish.
I regularly check the Internet for solutions, but I always end with something like "delete all items of list and add each row from CSV file" or then use a quite complicated Flow that finds the differences (new, gone, changed items). Both will cause a large amount of API Calls, too!
Who else thinks there should be a simpler solution to that, like "DELETE FROM myList WHERE true" and "INSERT INTO myList FROM CSV_File" if the columns of both CSV and SP List are identical? Or am I missing something?
