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
You could try Q1%2E%20Date%3A
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:
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
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.