You’re offline. This is a read only version of the page.
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.
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.
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
Hi @Anonymous ,
Try to surround each condition with cracket:
Share
Report
All responses (
Answers (
(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.
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
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
