Import maximum 30,000 excel items into SharePoint list using power automate

[jyotiRajpurohit]

Hi Team,

I have to import maximum 30,000 excel sheet items into SharePoint list using power automate. The help of pagination, I can import 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.

I have gone through this document - https://docs.microsoft.com/en-us/power-automate/limits-and-config
but I didn't find number of items per plan and what is the price for that.

For pagination threshold If I go with other plan like "MediumLow1" will it allow me for number of items as 100,000 ?

Kindly help me in this.

Thank You.