web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Why (Excel Online > Li...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 43

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

Categories:
I have the same question (0)
  • manuelstgomes Profile Picture
    6,625 on at

    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 Profile Picture
    43 on at

    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

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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

  • manuelstgomes Profile Picture
    6,625 on at

    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 Profile Picture
    7,781 Most Valuable Professional on at
    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

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard