cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Excel filter query, column name has special characters

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

2 REPLIES 2
mahoneypat
Solution Sage
Solution Sage

You could try Q1%2E%20Date%3A

 

Pat

DamoBird365
Community Champion
Community Champion

@Anonymous ,

 

You can check via the list in sharepoint via the cog settings -> list settings and clicking on the column in question.  You can then see the full name in the URL like so:

 

DamoBird365_0-1614449527087.png

In my case it was Q1_x002e_Date_x003a_ but you should just go and have a look on your own list.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,500)