cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Charles3
Level: Powered On

Re: 256 rows limit getting rows from excel

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

Microsoft Suresh
Microsoft

Re: 256 rows limit getting rows from excel

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

 

Highlighted
Charles3
Level: Powered On

Re: 256 rows limit getting rows from excel

Hello Suresh,

 

this works perfectly thank you !

gizar
Level: Powered On

Re: 256 rows limit getting rows from excel

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

Microsoft Suresh
Microsoft

Re: 256 rows limit getting rows from excel

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

 

Thanks & Regards, 

Suresh Koorella

nizam1011
Level: Powered On

Re: 256 rows limit getting rows from excel

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"

swbates
Level: Powered On

Re: 256 rows limit getting rows from excel

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.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,656)