Get Items with OData filter did not return all match items

(0) Share

Report

Posted on by JesperHuang

Hi Everyone,

I have a flow which will get items from my SP list and I'm using OData filter to get the data which need to update.

Originally it work like a charm, but recently I notice that get items action did not return all items match the filters and I did not change anything on my flow.

Weird thing is when I use ID field(which created automatically by SP list ) to filter the specific item, flow can get item properly.

But when I used original filter, it just can't return match items...

My OData filter as below:

(Title eq 'Test_Title_001/1')
and (USERID eq '1256807')

BTW, I'm not sure is that a problem my SP list items already over 5,000.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @JesperHuang

Could you try with Title filter only? Also try using USERID? See if that returns anything?

Thanks

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @JesperHuang :

You'd better add an index on 'Title' and 'UserID':

Usually your problem should be solved . If you still cannot get the expected result, you can increase the limit on the number of records you can obtain:

Best regards,

Bof

Was this reply helpful? Yes No
JesperHuang 56 on at

Like (0)

Report

Hi @abm ,

Thank you for your reply, I already try both its not working.

Was this reply helpful? Yes No
JesperHuang 56 on at

Like (0)

Report

Hi @v-bofeng-msft ,
I'll try to set index first then test if this problem can be solved, thanks.

Besides, I remember the top count limit up to 5,000 item only, is that acceptable to set top count as 9999?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report

Hi @JesperHuang :

The top count count can be set to 9999 and it will work.

Best Regards,

Bof

Was this reply helpful? Yes No