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
- To check the column name you could use the below URL to find the internal name of the column
_api/web/lists/getbytitle('List Name')/fields 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.
Strange issue BenMercer .
Only other thing I can think of is to check that your value 'To Do' doesn't contain an extra space after 'Do'. That would break your filter query if it does have it.
Otherwise, for now, I can't think of anything else to suggest trying.
Cheers
Damien
