Forum Discussion

BenMercer's avatar
BenMercer
Copper Contributor
Nov 15, 2023

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...
Microsoft Flow
ODATA Filter Query
PowerApps
SharePoint
Kelly_Edinger's avatar
Kelly_Edinger
Bronze Contributor
Nov 15, 2023
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.
  • BenMercer's avatar
    BenMercer
    Copper Contributor
    Nov 15, 2023
    Just tried it. Still doesn’t work even without the spaces unfortunately.
    • Damien_Rosario's avatar
      Damien_Rosario
      Silver Contributor
      Nov 17, 2023

      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

      • Rahul-Barua's avatar
        Rahul-Barua
        Copper Contributor
        Nov 17, 2023
        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

Resources