Hello
I can currently using the below flow that
- collects and excel table
- for each row in that table it checks to see if corresponding ID is in a sharepoint list
- either add a new line in the list if it isnt present or update a current line
However there are currently 10100 rows in the table. I am on the free version of Power Automate and in the action 'List rows present in the table' it will only pull out the first 5000. How can I fix this?
I have tried to Filter query using the command -> Opportunity Status eq '11. Closed Rolled Off'
however I get the error bad request even though I have checked that it matches what is shown in the excel table and outputs
I have also tried to skip count, but get this error:
Can anyone help as I want to be able to pull all these values into the SharePoint list each day.
