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.
Solved! Go to Solution.
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,
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,
Hello,
Will put lower pagination than the top count.
Thanks for your help.
User | Count |
---|---|
93 | |
45 | |
20 | |
20 | |
15 |
User | Count |
---|---|
134 | |
52 | |
44 | |
36 | |
27 |