Get Items Filter ODATA Query with special characters in column name

[Anonymous]

Hi

I have a Sharepoint List with a column with special characters in it, its called Öppen/Stängd (Open/Closed).

It's "Choice" type of column with three choices: Öppen, Stängd, Vilande (Open, Closed, Paused).

No matter how I try to format the ODATA Filter Query I just get errors. I found out the name from Column settings "url" in Sharepoint.

I have tried:

%D6ppen%2FSt%E4ngd eq 'Vilande' (results in "The $filter expression "%D6ppen%2FSt%E4ngd eq 'Vilande'" is not valid. Creating query failed."

_x00d6_ppen_x002f_St_x00e4_ngd eq 'Vilande' (results in Column '_x00d6_ppen_x002f_St_x00e4_ngd' does not exist. It may have been deleted by another user.)

[_x00d6_ppen_x002f_St_x00e4_ngd] eq 'Vilande' (results in The $filter expression "[_x00d6_ppen_x002f_St_x00e4_ngd] eq 'Vilande'" is not valid. Creating query failed.)

['_x00d6_ppen_x002f_St_x00e4_ngd'] eq 'Vilande' (results in The $filter expression "['_x00d6_ppen_x002f_St_x00e4_ngd'] eq 'Vilande'" is not valid. Creating query failed.)

So I have learned to always create columns without special characters and then renaming them, but unfortunatly this list includes to many records for me to delete the column and start over (although Im sure I could copy data from 

[ScottShearer · Accepted solution]

@Anonymous 

I have found that getting the internal column name from the URL in list settings doesn't always work.Try the following instead:

1. Create a new Flow with a button and a get items action
2. In your Get items action, set the top count to 1
3. Run the Flow
4. Click on the output of the Get items action in the run
5. Find the reference to your column in the output - refer to the column in exactly the same way in your query

[sudharsan1985 · Accepted solution]

@Anonymous 

I used the same column name that you had mentioned and created the choice column and used the below ODATA filter query to get the items

OData__x00d6_ppen_x002f_St_x00e4_ngd eq 'Choice 1'

Please try it and let me know.

[Anonymous]

This worked perfectly! Why is it that it needs the prefix "OData"?

[sudharsan1985]

Hi @Anonymous 

I am not sure why OData, but whenever you have field names with special characters try to run Get Items with the top 1 record, and from the JSON output you can clearly identify the column names that can be used in OData Query.

[sandrox2]

Awesome!

[heismodest]

Thanks to your comment, I could resolve my problem!!

Thank you so much~!!

Jeong-Min.