Get items skips elements with no filter applied and pagination on

[nicola_prad]

Hello everybody. 

I'm having some troubles with the "get items" action. 

I'm trying to retrieve all the elements of a sharepoint table with no filters applied in the "get items" action, but some of them are missing.

Everytime it skips the same elements. 

I've switched on the pagination

See pictures for an example. 

When i run the the flow below, the element with id=105 is always skipped

The result:

Both elements are in the table

Pagination is on.

In the table there are more or less 4k elements.

Any hint?

Thank you in advance!

[nicola_prad]

I've just tried to delete the "order by" string and in that case it gets all elements.

This behavior is pretty weird....

I need them sorted btw.

[Kaif_Siddique]

Update formula - @equals(item()['ID'], 105)

Regards

Kaif

[nicola_prad]

Hi Kaif. Thank you for your reply.

I get the same result.

That element is not there if I sort them.

I was quite sure because I needed it in the flow below and I had already checked the raw data.

[nicola_prad]

I've solved using a "Send an HTTP request to sharepoint" action instead of "Get Items".

However the above mentioned problem seems quite a bug to me.