I want to use a power automate process to insert data from a daily csv file into a customer dataverse table, however, there is the 5000 pagination restriction. What would be the best way to do this? Thanks for the advice. Also, is there a way (after the initial data load) to check for any existing records to either update, skip, or add new (from future files)?
