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.
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.
I've tried these but none of em worked for me.
And it gives me ' Column name not found ' error
Unfortunately this is not supported now in Excel ODATA Query for column with spaces.
You could vote for this idea.
The only solution for you is rename the existing excel column name without spaces.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
Check out the community blog page where you can find valuable learning material from community and product team members!