Excel filter query, column name has special character

[LittleBird23]

Hi all,

I want to list rows present in an excel file and apply a filter query to it. However, the column name in the filter has special characters. This I can't change.

Its currently Q1. Date:

and my filter query is Q1. Date: eq CourseDate (CourseDate being a user input)

I understand I need to replace these special characters with unicode to allow it to work as expected. Can someone help please?

Is it something like Q1_x002E__x0020_Date_x003A_ eq CourseDate

Thanks

[Paulie78]

Try:

Q1_x002e_ Date_x003a_

[LittleBird23]

Thanks for the reply @Paulie78. No joy, I get the following error:

Syntax error at position 21 in 'Q1_x002e_ Date_x003a_ eq '30/09/2020''.
inner exception: Syntax error at position 21 in 'Q1_x002e_ Date_x003a_ eq '30/09/2020''.
clientRequestId: c8a4b107-a8fb-444d-ae83-8e44ed502bc3.

Does the space not also have to be replaced by unicode?

[Paulie78 · Accepted solution]

So I tried this out, with an Excel table with the same column name, I could not get the filter query to work. If you can figure out a way to get it to work I would be interested to know what it is. Instead I put the output from Excel into a select to make the column names easier to work with, then put that into a filter:

If you want the dynamic content back then you can add a parse JSON step. Just a warning, your query probably wouldn't have worked anyway (in the way you imagined). Because your excel dates are actually integers, not dates.

Edit: The expression on the left side of the filter is:

item()['Q1_Date']