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 / OData Filter witha bla...
Power Automate
Unanswered

OData Filter witha blank space un column Name, ExcelOnline Block

(1) ShareShare
ReportReport
Posted on by 64

I have an Excel with a Column Named: 'Sumin Desc'.

I have to make a Filter Query using this column as:

 

"Sumin Desc" eq 'Value to filter'

or

  substringof('Value to filter',"Sumin Desc")

 

But I can`t find the specific name of this column to put in the filter. I tryed next options:

'Sumin Desc'

"Sumin Desc"

['Sumin Desc']

{'Sumin Desc'}

[{'Sumin Desc'}]

Sumin_x0020_Desc

[Sumin_x0020_Desc]

item(){'Sumin Desc'}

 

and It doesnot work,

 

With oder column name there is not problem, for example:

Title eq 'Value to filter'

 

Any solution?

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Evbelda 

     

    The space with column names are not supported for Excel ODATA query. The work around is use the Filter action step to use the filter.

     

    Thanks

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

    Hi @Evbelda 

     

    Please have a look at this thread

     

    OData filter column with space - Power Platform Community (microsoft.com)

     

  • Evbelda Profile Picture
    64 on at

    This solution it is not valid.

     

    The answer for "Get rows" in Excell is:

    [
      {
        "@odata.etag""",
        "ItemInternalId""fa2b57ed-a9f6-4314-8599-c91b880cd90f",
        "IDTexto""xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
        "Sumin Desc""xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    ..........
     
    If I use Filter Array the name of the column is:
    item()?['Sumin Desc']
    And I tried this posibility
     
    In the other hand I cant put a "Get Rows" block and filter it after. I need to Filter it in the ODATA because there are more than 5000 rows in the file and one of the columns to filter is "Sumin Desc"
     
    Also I tried 
    Sumin_x0020_Desc
    And It doesn't work
    Any other Idea?

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 784

#2
Valantis Profile Picture

Valantis 589

#3
Haque Profile Picture

Haque 522

Last 30 days Overall leaderboard