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

Notifications

Announcements

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,865 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,865 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard