Unanswered

Reading more than 5000 excel row

(0) Share

Report

Posted on by Khai_Lunkim

Hello Everyone!

I'm currently running into the issue of trying to read more than 5000 excel records for my flow. I understand upgrading my plan will increase the pagination limit to 100,000 but that is not possible for me and I have looked into other solutions but could not find any relevant ones.

Also FYI, when I set my trigger point as manual I am allowed the 100,000 limits but I need my trigger to be "when a new file is created" but I get the above error message.

Also another FYI 🙂

All I need my flow to be doing is the below just able to read the excel file which is going to contain anywhere from 20,000 - 80k or 100k

Please help! Thanks

All responses (2)

Answers (0)

Khai_Lunkim 72 on at

Like (0)

Report

Re: Reading more than 5000 excel row

Hi Kaif!

This was very helpful but I don't know how to get all parsed data or all of the data for the 'List rows present in a table' step
I'm currently composing each output of the 'List rows present in a table' and trying to join all iterated composed value
I need this so I can parse the collective data and create a CSV table accordingly but I'm getting the below error
Is there anyway to collect all iterated data and parse them?

Thanks,
Khai
Kaif_Siddique 2,104 Super User 2024 Season 1 on at

Like (0)

Report

Re: Reading more than 5000 excel row

Hi @Khai_Lunkim ,

Use the below link to parse large excel file:
https://piyushksingh.com/2020/07/06/power-automate-read-excel-file/

Hope this will help.

Regards
Kaif