You’re offline. This is a read only version of the page.
I need some help with a filter on a spreadsheet. This follows a 'list rows present in a table' action. The goal of the flow is to update or create items in a sharepoint list.
One of the columns is called project phase. I want to filter out all projects where the phase is either empty or closed.
I currently have this set up using two conditions inside an apply to each action. However, this is very slow and the flow takes over 1 hr to complete.
I know I can use the filter array to do this, but how do I set it up to test for both empty and closed items? And how do I tie this in with the updating/creating of a sharepoint item?
It does not take more than one condition in filter array advanced mode. Has this feature been deprecated ?
Speaking as of August, 2021.
How to handle the case when no row matches a criteria ? It throws me an error saying that row with ID "xx" not found even after I have specified a child process which is configured to run only if the parent fails to run.
can we also use StartsWith with the column name from a excel sheet while using filter array ? If yes, how do we write it ?
Hi @Brad_Groux,
My flow to add feedback to excel rows, based on matching to the first column 'Message ID' is to slow to use, I think your above solution may help but I am not sure - please take alook:
You can simply overlay filters array
The first condition is a normal filter array
The second filter array should take the body from the first filter array, the condition item should be item()?['Date']
I'm going with the filter 🙂
I'm trying to implement it now. Wouldn't your solution accomplish the opposite of what I am trying to accomplish? I'm trying to go ahead with a list that does not contain empties and closed projects. Either way, I've changed it to the 'contains t' and that works!
I managed to get the odata filter working in a sense; it now throws a 502 error though.
Share
Report
All responses (
Answers ({
Hi @RobinV86 ,
Have you tried the method I provided?
Please let me know if you have any question.
Best Regards,
I've tried the filter query solution first but I am getting error messages as a result.
All the project phases i want to filter for coincidentally include the letter t, so I've been trying:
substringof(Current_x0020_Phase, 't')
{
"status": 400,
"message": "An unknown function with name 'substringof' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.\r\n inner exception: An unknown function with name 'substringof' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.\r\nclientRequestId: 12948adb-a95b-4481-a645-7e6260456f27",
"source": "excelonline-ase.azconn-ase.p.azurewebsites.net"
}and variations of this as posted in the link provided. This doesnt seem to work.
Edit. Also no luck using
Project_x0020_Reference NE '' or Project_x0020_Reference NE 'Closed'
{
"status": 400,
"message": "Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.\r\nclientRequestId: 41cc9017-7078-4849-bf0a-7ebc3abd9cb5",
"source": "excelonline-ase.azconn-ase.p.azurewebsites.net"
}
Hi @RobinV86 ,
I did a test on my side, please refer to the following method to configure Flow.
Expression reference:
@or(equals(item()?['project phase'], ''),equals(item()?['project phase'], 'closed'))
Image reference:
Hope it helps.
Best Regards,
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
