Skip to main content

Notifications

Power Automate - General Discussion
Answered

How to oData filter a Choice Column with Multiple Selection

(0) ShareShare
ReportReport
Posted on by 21

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

 

masanortakamoto_0-1662441666940.png

 

Sample Run

masanortakamoto_1-1662441743114.png

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

 

  • victorcp Profile Picture
    victorcp 2,347 on at
    Re: How to oData filter a Choice Column with Multiple Selection

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

  • masanortakamoto Profile Picture
    masanortakamoto 21 on at
    Re: How to oData filter a Choice Column with Multiple Selection

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

  • masanortakamoto Profile Picture
    masanortakamoto 21 on at
    Re: How to oData filter a Choice Column with Multiple Selection

    Not yet. Should I set it to just 5000?

  • Verified answer
    victorcp Profile Picture
    victorcp 2,347 on at
    Re: How to oData filter a Choice Column with Multiple Selection

    Hi,

    Have you turned on the pagination of the get items?

     

    victorcp_0-1663176200403.png

    victorcp_2-1663176271817.png

     

     

  • masanortakamoto Profile Picture
    masanortakamoto 21 on at
    Re: How to oData filter a Choice Column with Multiple Selection

    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.

  • victorcp Profile Picture
    victorcp 2,347 on at
    Re: How to oData filter a Choice Column with Multiple Selection

    Change the odata filter to

    substringof('Released', OrderStatus)

     

  • Re: How to oData filter a Choice Column with Multiple Selection

    Hi @masanortakamoto ,

     

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

    1\My SP List

    vbofengmsft_0-1662451799437.png

    2\My Flow

    vbofengmsft_1-1662451813646.png

    3\Result

    vbofengmsft_2-1662451837272.png

     

    Please consider checking the data source or spelling .

     

    Regards,

    Bof

     

     

  • victorcp Profile Picture
    victorcp 2,347 on at
    Re: How to oData filter a Choice Column with Multiple Selection

    Hi,

    try this:

    substringof('value', ColumnName)

     

    victorcp_1-1662451038542.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard