Unanswered

Get Items Filter ODATA Query with special characters in column name

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (5)

Report
@Anonymous

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

Create a new Flow with a button and a get items action

In your Get items action, set the top count to 1

Run the Flow

Click on the output of the Get items action in the run

Find the reference to your column in the output - refer to the column in exactly the same way in your query

Was this reply helpful? Yes No
Verified answer

sudharsan1985 1,325 on at

Like (4)

Report
@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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

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

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
sandrox2 6 on at

Like (0)

Report

Awesome!

Was this reply helpful? Yes No
heismodest 8 on at

Like (0)

Report

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

Thank you so much~!!
Jeong-Min.

Was this reply helpful? Yes No