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

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.

Hello,

 

Will put lower pagination than the top count.

 

Thanks for your help.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,359)