Get Items Filter Query Not Working

(1) Share

Report

Posted on by MN003

441

Hello,

I have a SharePoint list with a choice column that was originally named Sample3. I changed the column name to Project Status (with a space in between). I'm trying to get the items from that SharePoint list but filter on that choice column to get the items that aren't equal to 'Completed' or 'Cancelled'.

I've tried these three cases in the filter query but keep getting an error that says the query isn't valid:

Project Status ne 'Completed' or 'Cancelled'

Project Status Value ne 'Completed' or 'Cancelled'

Sample3 ne 'Completed' or 'Cancelled'

Am I missing something? Or is there something else I should try? I would appreciate any guidance. Thank you!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @MN003

Pls try the below filter query:

ProjectStatus ne 'Completed' or ProjectStatus ne 'Cancelled'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
MN003 441 on at

Like (0)

Report

Hi @ManishSolanki,

Thank you so much for the quick reply. That helped me get to the solution. I replaced the ProjectStatus with the original column name of Sample3 and it worked.

Sample3 ne 'Completed' or Sample3 ne 'Cancelled'

Thank you very much!

Was this reply helpful? Yes No