How do I filter data twice?

(0) Share

Report

Posted on by JasonM73

147

Morning

I am using a stock template to list my Planner tasks, then filter on Bucket ID for a specific bucket the filter on percentage completed. I have got the output nearly there but I can not understand how to filter the output twice?

Here is what I have

This gives me this

So my question is please how to filter out the completed tasks (i.e. the 100% ones)?

Thanks

Jason

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
There are two methods:

You can change the first filter action to advanced mode and use the and function to apply two filters in one action.

You can add another filter array after your first filter using the output of your first filter as the input for the second one. You will then need to change the subsequent actions to use the output of the second filter.

Does that make sense?

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
JasonM73 147 on at

Like (0)

Report
Copy link

Link copied!

Thanks, if I add a second filter array, what would be the From value?

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
JasonM73 147 on at

Like (0)

Report
Copy link

Link copied!

thank you @Paulie78 - that solved my issue. I had to tweak the inputs from the previous steps but all working as intended - many thanks for the help 😊

Jason

Was this reply helpful? Yes No