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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,584)