Get Items Filter Query Not Working

(1) Share

Report

Posted on by MN003

422

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!

All responses (2)

Answers (0)

MN003 422 on at

Like (0)

Report

Re: Get Items Filter Query Not Working

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!
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report
Re: Get Items Filter Query Not Working

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.