Answered

How to oData filter a Choice Column with Multiple Selection

(0) Share

Report

Posted on by masanortakamoto

I have a flow that filters a list of items in a sharepoint list. It does not filter the data even if I can still see items that has the condition within the list. Upon checking the sample run of the flow, the oData filter did not result to anything.

OrderStatus column is a "Choice" field that allows multiple selection

Would appreciate the help regarding this one. Thanks!

Power Apps action

Sample Run

In the list I still have items that are tagged as "Released"

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,
try this:
substringof('value', ColumnName)

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

Like (0)

Report
Copy link

Link copied!

Hi @masanortakamoto ,

I've made a test but did not encountered the problem you mentioned.

1\My SP List

2\My Flow

3\Result

Please consider checking the data source or spelling .

Regards,

Bof

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
Change the odata filter to
substringof('Released', OrderStatus)

Was this reply helpful? Yes No
masanortakamoto 21 on at

Like (0)

Report
Copy link

Link copied!

Hello! Apologies for the delayed response I got covid T_T. Anyway, it seems it's not working on my list. I am not sure if the number of items in the list is affecting the performance because it is already over 33,000 items.

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,
Have you turned on the pagination of the get items?

Was this reply helpful? Yes No
masanortakamoto 21 on at

Like (0)

Report
Copy link

Link copied!

Not yet. Should I set it to just 5000?

Was this reply helpful? Yes No
masanortakamoto 21 on at

Like (1)

Report
Copy link

Link copied!

Now I am able to filter items, but I need to archive! Thank you!

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!

The maximum that I can set is 5000 (license limitation), I suggest using the maximum that your license permits

Was this reply helpful? Yes No