cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmitLoh-Powerap
Kudo Kingpin
Kudo Kingpin

256 rows limit getting rows from excel

256 rows limit getting rows from excel. I am not able to get more than 256 rows from excel located on ftp in flow. I have 400 rows in excel. It only gives me 256 rows.

48 REPLIES 48

Awesome! Works like a treat! Many thanks @Nikolaos 

MBates
Frequent Visitor

When I change my pagination settings and save my flow, I get this:

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "The requested resource doesn't exist.\r\nclientRequestId: 9bb069e3-50bf-4964-ab1e-0536108b433f\r\nserviceRequestId: a4d38db2-c560-45c1-bd0e-159aefa2edb3", "error": { "message": "The requested resource doesn't exist." }, "source": "excelonline-cus.azconn-cus.p.azurewebsites.net" }'.

sajarac
Super User
Super User

Hello MS Guys.

 

Quick question. I am trying to copy my giant excel file "close to 1M rows by 12 columns" I have a combination of Text and Date columns".

 

Could you please let me know How many hours this operation will take? and also is possible to copy all those rows? or only the maximum threshold of 100000?

Powerplatform01
Post Patron
Post Patron

@AmitLoh-Powerap 

Refer this video to resolve your issue.Also request you to please subscribe this channel

https://youtu.be/HFghBAYX-oQ

Hi @Nikolaos , just curious. How many hours took for this operation to be completed?

Hi there, 

i am really sorry to say that I truly don’t remember but I don’t think it was more than a few hours. 3-4 maybe. 

hope it helps you

Thank you very much for your prompt response. I will continue investigating.

Just FYI.

Unbelievable. 8 Hours for 8,000 rows. !!!

 

sajarac_0-1630495650577.png

 

KennyTheFarmer
Frequent Visitor

I just struggled with the same 256 row limitation.  Changing the pagination settings allowed me to load all rows.  Thanks for the solution. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,048)