Announcements
Hi Power Rangers,
I am trying to limit my column to retrieve with Select query, however, it appears that my column with a space is resulting in a bad request. Could it be a bug?
Here's my sample table.
HI @Moosa
Try using 'Userx0020Name'. You need to encode the space otherwise the query will fail.
If I have answered your question, please mark your post as Solved.If you like my response, please give it a Thumbs Up.
CheersManuel
Hi @manuelstgomes
I've tried these but none of em worked for me.
-> %20
-> x0020
-> _x0020_
And it gives me ' Column name not found ' error
Hi @Moosa
Unfortunately this is not supported now in Excel ODATA Query for column with spaces.
You could vote for this idea.
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Have-Consistency-in-on-Filter-Query-and-Order-By-on-Excel/idi-p/297122
The only solution for you is rename the existing excel column name without spaces.
Thanks
@abm is correct. Sorry I missed that you were accessing an Excel file.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 250 Super User 2026 Season 1
Expiscornovus 222 Most Valuable Professional
Haque 174
