cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Why (Excel Online > List rows present in a table) action resulting bad request when entering value with space in Select query?

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?

spacedSelectQuery.PNG

 

Here's my sample table.

excelDummy.PNG

5 REPLIES 5
Super User II
Super User II

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.

Cheers
Manuel

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

Capture1.PNG

Super User III
Super User III

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-Ord...

 

The only solution for you is rename the existing excel column name without spaces.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

HI @Moosa 

 

@abm  is correct. Sorry I missed that you were accessing an Excel file.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Super User III
Super User III

Hello @Moosa

Check out my blog here:
https://flowaltdelete.ca/2020/04/12/excel-filtering-columns-with-space/

It’s exactly what you are looking for




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (21,386)