Skip to main content

Notifications

Community site session details

Community site session details

Session Id : m0H2ZhNbnlqSdB5usHlU3c
Power Automate - General Discussion
Answered

Filter Query in List rows in a table Error

Like (0) ShareShare
ReportReport
Posted on 28 Sep 2022 17:47:51 by 60

I am trying to filter my Excel document for certain values using Power Automate and then emailing the resultant rows. 

 

Currently, my flow looks like: 

Capture1.PNG

 

I am basically filtering on a column in my data set called 'ERP Site Location Code' for a certain value and receiving all associated rows. However, I get the following error: ')' or ',' expected at position 7 in 'eq(ERP Site Location Code, "ZCOW1")'.

 

I don't understand what I'm doing wrong. I also did verify my excel file contains the correct column name: 

tareenmj_1-1664387232662.png

 

 

  • Sundeep_Malik Profile Picture
    6,480 on 29 Sep 2022 at 14:23:58
    Re: Filter Query in List rows in a table Error

    @tareenmj

    Yup I know, faced one situation today. I had made a flow yesterday. Today it gave error in 1 variable. Copied the same flow line by line, expression by expression and made another flow and its working fine. And the first flow is still giving error.

  • tareenmj Profile Picture
    60 on 29 Sep 2022 at 14:20:41
    Re: Filter Query in List rows in a table Error

    Thanks Sundeep! Your answers and recommendation was very helpful. I did try removing spaces from my Excel file and i was able to receive data within 3 seconds (my excel file has a count of 250k rows). I did have a feeling that fetching all rows would drastically reduce performance and obviously with an excel file with that many rows, I would have to do some batch processing. I'm just going with the removing spaces approach but I don't like how power automate is so buggy.

  • Sundeep_Malik Profile Picture
    6,480 on 29 Sep 2022 at 13:55:18
    Re: Filter Query in List rows in a table Error

    @tareenmj 

    That would definately affect the performance.

    Renaming the excel columns will be the best way.

     

    So let's say: you have 100 rows in your excel with filter query you are just fetching the required rows. 

    But with Filter array you will be fetching entire rows and then processing. 

     

    Just check out the below batch process that might help to reduce your flow times for excel processing: 

     

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

  • tareenmj Profile Picture
    60 on 29 Sep 2022 at 13:34:56
    Re: Filter Query in List rows in a table Error

    Thanks for the input, would this result in similar time performances? A) If I receive all results, and then do a filter array, and B) Changing the column names to perform a Filter Query? 

  • Verified answer
    v-liwei-msft Profile Picture
    on 29 Sep 2022 at 09:48:47
    Re: Filter Query in List rows in a table Error

    Hi  @tareenmj 

     

    This is a known limitation, the Filter Query in List rows present in a table action does not support the use of fields with spaces in the field name as filter parameters.

    I suggest you to use the Filter array feature.

     

    Best Regards,

    Levi

  • Sundeep_Malik Profile Picture
    6,480 on 28 Sep 2022 at 19:12:56
    Re: Filter Query in List rows in a table Error

    @tareenmj 

    Try without spaces.

  • tareenmj Profile Picture
    60 on 28 Sep 2022 at 18:34:10
    Re: Filter Query in List rows in a table Error

    Thank you for the help, I tried that and seem to be receiving the same error and I think it is because of the fact that my Column name has spaces, I even tried doing: eq(ERP_x0020_Site_x0020_Location_x0020_Code, 'ZCOW1') but this results in another error saying: Invalid filter clause: cannot find the 'ERP_x0020_Site_x0020_Location_x0020_Code' column.

     

    I think this has to do with spacing but I'm unsure on how to reference a space in Power Automate

  • Sundeep_Malik Profile Picture
    6,480 on 28 Sep 2022 at 18:14:19
    Re: Filter Query in List rows in a table Error

    Hey @tareenmj 

    Not sure that syntax works or not.

    Try writing the below syntax:

     

    Column name eq 'Value'

     

    So for you:

     

    ERP Site Location Code eq 'ZCOW1'

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard