Forum Discussion
ODATA Filter Query not valid when it should be
Hi, I’m deeply confused with Power Automate Get Items ODATA Filter Queries. They are completely illogical. With one choice column called “Status”, it works absolutely fine. With another choice co...
Have you tried using SwayStatus? When you go into List Settings and then click the column, the URL will show you the true column name at the end of the URL. It won't have any spaces.
- Just tried it. Still doesn’t work even without the spaces unfortunately.
Hi BenMercer
If SwayStatus eq 'To Do' didn't work, you can also try Sway_x0020_Status eq 'To Do'.
Cheers and best wishes
Damien
Damien_Rosario this didn’t work either. Same bad request error. Like I said, it clearly knows the column exists, otherwise it throws back a different error when it can’t find the column. The bad request error seems to be it saying it’s found the column, but is complaining that the syntax is wrong, when it isn’t.
