cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sababneh
Advocate III
Advocate III

Is this a bug in Get Item SharePoint List?

Hello,

 

I'm using Get Items activity to pull some items from a SharePoint list, and it was working fine, now I tried pulling 40 items (top number) and it only returned 13, and when I tried to increase the Pagination from Settings to 1k, it returned 1k. Please check the images below, the compose is the length.

 

Pagnation.pngPagnation.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @Sababneh ,

 

I did a test on my side. The results returned by the Get items action depend on multiple settings, and the priority of each setting seems to be different in different situations.

 

After enabling Pagination, if the number set in Threshold is greater than the number set in Top count, then Get items action will return all items that meet the filter criteria. Ignore the setting of Top count field.

 

If the number set in Threshold is less than the number set in Top count, then the items will be obtained according to the number set in Top count.

 

In addition, each time we set Pagination, we need to click Done to apply the settings.

 

Best Regards,

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

View solution in original post

2 REPLIES 2
v-bacao-msft
Community Support
Community Support

 

Hi @Sababneh ,

 

I did a test on my side. The results returned by the Get items action depend on multiple settings, and the priority of each setting seems to be different in different situations.

 

After enabling Pagination, if the number set in Threshold is greater than the number set in Top count, then Get items action will return all items that meet the filter criteria. Ignore the setting of Top count field.

 

If the number set in Threshold is less than the number set in Top count, then the items will be obtained according to the number set in Top count.

 

In addition, each time we set Pagination, we need to click Done to apply the settings.

 

Best Regards,

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

View solution in original post

Hello,

 

Will put lower pagination than the top count.

 

Thanks for your help.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Users online (1,110)