cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MRauscher
Advocate II
Advocate II

Condition is only about 100 entries

Hello,

 

I have the following problems:I have a list of over 4000 entries. Each entry has several columns of data. With Elemete retrieve I want to retrieve all entries. Then I want to create a query that is one older than the current date into a new list.But he always asks me only 100 entries and not all!Do I have to set a filter to get the appropriate entries or where is the error?

image.png

 

 

thx Michael

1 ACCEPTED SOLUTION

Accepted Solutions
MRauscher
Advocate II
Advocate II

Hello Guys,

 

I build a detour to the solution. But it is not quite the right way.

I sort list by the appropriate column and ask only the first 1000 items.

There are my desired items and so the flow was successful.

 

Thx for your help

 

Greetings Michael

View solution in original post

4 REPLIES 4
v-micsh-msft
Community Support
Community Support

Hi @MRauscher,

 

Thanks for posting.

This should be related with the Top Count. B y default the Get Items action will only get the first 100 items, with the (default = all ) under Top count, if here you would like to get the proper number items, please take a try to specify the corresponding number of the items.

For example:

16.PNG

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MRauscher
Advocate II
Advocate II

Thanks for the answer.
Unfortunately it did not work. I always get a GatewayTimeout error.
I started with 5000 items and then went down to 3000 Itmes.
But I have to check the whole list and not just part of it.
Are there any limits to list editing in Flow?

Duration: 2m
Start time: 2017-12-04T07: 56: 38.787877Z
End time: 2017-12-04T07: 58: 18.8223292Z
Status: GatewayTimeout
Client Request ID: 464224bf-2e4c-4750-8296-2d0f5caf2ab0
Service Request ID: 464224bf-2e4c-4750-8296-2d0f5caf2ab0

{
   "status": 504,
   "message": "A task was canceled. \ r \ nclientRequestId: 142679a2-3724-4763-aa9d-c23ca429ae36",
   "source": "https://sharepointonlineconnectionprovider-westus.tip0-westus.p.azurewebsites.net/datasets/https%253... -bb0e-0ff348a04749 / items? 24top% = 3000 "
   "errors": []
}

Hi @MRauscher,

 

Thanks for your feedback.

There is no limits related to Gateway timeout in the article below:

SharePoint connector

 

I will discuss this with other and send the feedback from my side.

And I will update here once I got any response back.

 

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MRauscher
Advocate II
Advocate II

Hello Guys,

 

I build a detour to the solution. But it is not quite the right way.

I sort list by the appropriate column and ask only the first 1000 items.

There are my desired items and so the flow was successful.

 

Thx for your help

 

Greetings Michael

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,120)