Unanswered

List rows // Excel // Filter Query // Problem with multiple Filters with Symbols in Column names and values

(0) Share

Report

Posted on by Community Power Pla...

Hi,
i was successfully running my flow until i tried to add more filter queries @list rows present in a table.

Successfull version-> Filter Query: Stage eq 'Running'

Error at-> Filter Query: Stage eq 'Running' and Project Requestor (OU) ne ' North America' and Project Requestor (OU) ne 'Materials Processing & North America'

"Project Requestor (XY)" is column name whereas i have to filter out a String value with "&" in it..

So i can't really locate the problem.
List rows_FilterErr.png

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

i get the following error message:

Syntax error at position 40 in 'Stage eq 'Running' and Project Requestor (OU) ne 'Materials North America' and Project Requestor (OU) ne 'Materials Processing & Services North America''.

So the problem is "(" and ")" as column names but the excel file is getting generated by a bot so i can't change them. How can i assure that these symbols get accepted

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Hi @Anonymous ,

Try to surround each condition with cracket:

(Stage eq 'Running') and (Project Requestor (OU) ne ' North America') and (Project Requestor (OU) ne 'Materials Processing & North America')

If it doesn't work either, you can put the 2nd and 3rd filter query in a "Filter query".

Reference:
OData Filter query in SharePoint Get items in Flow [5fce-5b2d-9d9-4dce] (sharepains.com)

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Unfortunately after i followed your advice i get the following message:

')' or operator expected at position 34 in '(Stage eq 'Running') and (Project Requestor (OU) ne 'Materials North America') and (Project Requestor (OU) ne 'Materials Processing & Services North America')'.
inner exception: ')' or operator expected at position 34 in '(Stage eq 'Running') and (Project Requestor (OU) ne 'Materials North America') and (Project Requestor (OU) ne 'Materials Processing & Services North America')'.
clientRequestId: 883603b6-bd94-4486-b724-0c90c88febf5

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I can filter the table with an external action "Filter Array":

@And(not(equals(item()?['Project_x0020_Requestor_x0020_(OU)'], 'Materials North America')), not(equals(item()?['Project_x0020_Requestor_x0020_(OU)'], 'Materials Processing & Services North America')))

now how can i extract a column out of this filtered array/table into an array?
Like after filtering out project with the condition i mentioned now i get a reduced table and out of it i want to extract the column "Project Manager" to get their names into an array.

Trying the above mention method i get the following error:
The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Was this reply helpful? Yes No