In Power Automate, i cannot use 'Get items' action and use a combination of filter/logic to retrieve SPO items.

Edward 86 Reputation points
2026-08-26T14:57:22.35+00:00

These two below are not working. I do have a dropdown/Choice column named 'Status' so please advice.

Status is a dropdown and it can be A, B, C, D, and E. I want to retrieve ones that are A and B.

Didn't work

Status eq 'A' OR Status eq 'B' OR Status

Status ne 'Resolved' AND Status ne 'Closed'

This one worked so i confirm the column exists

Status ne 'Resolved'

User's image

I tried asking 'Copilot' but that thing is so unhelpful.

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Heimerdinger 295 Reputation points Independent Advisor
    2026-08-26T15:52:20.2533333+00:00

    Hello @Edward, 

    I'd like to gather a little more information so we can narrow down the cause. 

    Are you seeing the following error when running the flow? 

    "Flow run failed. Action 'Get_items' failed: Column 'Status' does not exist. It may have been deleted by another user." 

    If so, Status may be the column’s display name rather than its internal name. Please find the internal name by following these steps: 

    1. Open the SharePoint list. 
    2. Select Settings > List settings.  User's image
    3. Under Columns, select the Status column.  User's image
    4. Check the browser address bar on the column settings page. 
    5. Look for the value after Field= near the end of the URL. 

    Please share the value shown after Field=. You do not need to share the complete SharePoint URL. 

    On my side, I found that the internal name was Test. Therefore, I changed the filter query from: 

    Status eq 'A' or Status eq 'B'  

    to: 

    Test eq 'A' or Test eq 'B' 

    Please try replace Test with the exact internal name shown after Field= on your side. The internal name is case-sensitive, so please copy it exactly as displayed. 

    If the first query still fails, could you confirm: 

    1. Is Status configured to allow only one selection or multiple selections? 
    2. What exact error appears in the flow run history? 
    3. Was the column originally created with another name and later renamed to Status? 

    If I have misunderstood any part of the configuration, feel free to clarify. I want to make sure I fully understand the setup before suggesting further steps. 

    Thank you again for your time and understanding. I really appreciate your patience, and I’m here to help. Looking forward to your response.   

    If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment".    

    Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.   

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-08-26T14:57:36.1533333+00:00

    Use OData operators in lowercase.

    For SharePoint Get items, supported operators include eq, ne, and logical combinations such as:

    • Location eq 'Midwest' and Status eq 'Approved'
    • startswith(Title, 'A')

    So for the Status column, use:

    Status eq 'A' or Status eq 'B'

    And for excluding values, use:

    Status ne 'Resolved' and Status ne 'Closed'

    Key points:

    1. Use or and and in lowercase.
    2. Use the SharePoint column name in the filter query.
    3. For string values, keep the values in single quotes.
    4. If the column is a Choice column, this syntax is the correct OData pattern for matching the stored text value.

    If the filter still returns no results, verify that the column name being used is the actual SharePoint column name and that the choice values match exactly.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.