Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 375 Super User 2025 Season 2
David_MA 269 Super User 2025 Season 2
Expiscornovus 127 Most Valuable Professional
