Hi Team,
I have to import maximum 30,000 excel sheet items into SharePoint list using power automate. The help of pagination, I can get 5000 items but here we have requirement for more than that.

Also noticed one issue like if excel sheet has more than 5000 items.
for example excel sheet has 10,000 items, when I use "Excel Online (Business)" and I set pagination threshold as 5000 but it gets the 5120 items. while importing items into SharePoint list it gives an error in for each loop.

Kindly help me in this.
Thank You.


