web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issue with filtering d...
Power Automate
Suggested Answer

Issue with filtering data with Choice column in Get Items

(0) ShareShare
ReportReport
Posted on by
Hi everyone,
 
I’m not sure what changed, but the “Get items” procedure had been working as expected since it was created and has suddenly stopped returning any data this week.
Cancelled column is a Choice column in our SharePoint list with 'Yes', and 'No' values. 
 
This is what the data looks like when I tested without any conditions.
 
"Cancelled": {
          "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
          "Id": 0,
          "Value": "Yes"
        },
"Cancelled#Id": 0
 
Tried different conditions but nothing is working:
'Cancelled/Value' eq 'Yes'
Cancelled/Value eq 'Yes'
Cancelled_x0020_Value eq 'Yes'
Cancelled_Value eq 'Yes'
Cancelled#Id eq 0
'Cancelled#Id' eq 0
Cancelled/Id eq 0
'Cancelled/Id' eq 0
Cancelled eq 0
 
Any suggestions please?
Categories:
I have the same question (0)
  • Suggested answer
    Sunil Kumar Pashikanti Profile Picture
    1,286 Moderator on at
     
    This is expected behavior with SharePoint Choice columns.
     
    In Get items, you can’t reliably filter on Cancelled/Value.
    SharePoint only supports filtering on the choice ID.

    Try below:
         Cancelled/Id eq 0
    OR
          item()?['Cancelled']?['Value'] equals 'Yes'
     
     
    ✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
    👍 Feel free to Like the post if you found it useful.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 523

#2
Valantis Profile Picture

Valantis 318

#3
David_MA Profile Picture

David_MA 235 Super User 2026 Season 1

Last 30 days Overall leaderboard