Answered

ODATA filter does not work in list in sharepoint

(0) Share

Report

Posted on by Guicord101

151

Hi Guys!

I'm dealing with a problem I've never seen before in 2 years of using Power Automate, my ODATA filter doesn't work.

I have a list in sharepoint that contains a column with several codes, the column format is "Text with one line". The column name is CodigoCentroCusto.

I have another flow that goes through all the items in this list and does some validations for each code in this column. Over the days I realized that this flow was failing and I looked for the reason...
For some codes, the result of the "Get Items" action simply returns blank data!
See:
In my list, there is a code with the number "3201395" and I can even filter it in the sharepoint list.

But when I have to run a flow to get this item within Power Automate, it just doesn't work.

The strangest thing is that for some codes it works normally.

Categories:

General topics

All responses (3)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @Guicord101
Can you check if you use the internal column Name in SharePoint List?

You could consider not configuring Filter Query first. After Get items action is executed, check the name of this field in Body, as below:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang
Verified answer

Guicord101 151 on at

Like
a
(0)

Report
Copy link

Link copied!

I discovered that the ODATA filter has a limitation of 5000 items for non-indexed columns. I activated indexing and I'm running the tests again, I'll post the results here soon.
v-yueyun-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi , @Guicord101
According to your description, you have above 5000 items in your SharePoint .
And as searched, it seems it is a known limitation :
While using Get items on lists with more than 5000 items with a filter query, you may observe that no records are returned if there are no items matching the filter query in the first 5000 items. To fix this, enable Pagination on Get items from the action settings menu when working with lists with more than 5000 items.

So, you can try to open your Pagination on Get items from the action settings menu:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang