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.

42 REPLIES 42
Charles3
Regular Visitor

Hello,

 

I'm facing the same issue on the Flow "List rows present in a table".

No matter if I put an value in the "Top Count" or let it empty, the first 256 rows are returned in the body('actionName')?['value'] parameter but the rest is put in an URI with the parameter body('actionName')?['@odata.nextLink'].

 

Example :

{
  "@odata.context": "https://excelonline-we....",
  "value": [
    {
      "@odata.etag": "",
      "ItemInternalId": "34cd99d3-d925-4212-89c8-d21c11ce4075",
      "Item" : 1
    },
    {
      "@odata.etag": "",
      "ItemInternalId": "6ddf51df-8d2b-4137-ab8f-b562af267b15",
      "Item" : 2
    },
    ...
    {
      "@odata.etag": "",
      "ItemInternalId": "71f1b8c5-de34-447a-b259-024738052573",
      "Item" : 256
    }
  ],
  "@odata.nextLink": "https://flow-.../tables/1/items?source=me&%24top=144&%24skip=256"
}

 

I can't loop on the content of the parameter "@odata.nextLink", is there a configuration to retreive all data in the body('actionName')?['value'] ?? 

 

Thanks for your answer

Hello Charles, 

 

Current query is for different connector 'ExcelOnline', whereas this thread was for a question in regular 'Excel' connector. 

 

ExcelOnline connector supports pagination, hence it is returning limited results along with next link. Which is expected. 

To consume all records from a paginated operation, you need to enable pagination in the action that you are configuring. Pagination setting is located under action settings, screenshot attached. 

 

Best Regards,

Suresh Koorella

 

Hello Suresh,

 

this works perfectly thank you !

gizar
Regular Visitor

Hello,

 

Thanks for your explanation that's exactly what I wanted.

Do you think it would be possible to add this information in the docs for the Excel connector?

 

Doc : https://docs.microsoft.com/en-us/connectors/excelonlinebusiness

 

Thank you

Thanks Gizar for the feedback. We will review and add the relevant note at all applicable places.

 

Thanks & Regards, 

Suresh Koorella

Anonymous
Not applicable

I tried it - it worked.

I have a excel table with 700+ rows.

I use flow to update a sharepoint list. I used to do one flow for every 256 rows.

After the pagination thing - it worked in one flow.

 

Checking a time comparison.

 

Thanks for the "Pagination"

Thanks everyone, I just had this happen today and the pangination appears to be working fine.  Is 2048 still the max limit?  I'm expecting to hit closer to 3000 lines.

Just tried it with 22.000 records. It worked perfectly.

@Nikolaos what configuration did you do? I'm also having an excel sheet with about 25,000 rows. Thanks!

@Framil_A I print screened my config for you. This setup worked for me. Pls try. Hope it helps

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (2,475)