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

[Moosa]

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.

[manuelstgomes]

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

[Moosa]

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

[abm]

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

[manuelstgomes]

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

[Jcook]

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