Filtering a string based on an array

*My goal is to filter so that only the text strings that contain ANY of the values in a set array go to the next step
I’ve tried doing array filters and text filters using the contains function



Screenshot 2024-06-13 at 11.49.07 PM
Here are all the screenshots including the array im trying to use to filter and also the text string I’m trying to check. Please let me know if you have any solutions, I’ve been racking my brain for hours on this probably simple issue.

Hi @AutomationNoob ,

Welcome to Make Community!

This filtering we can’t do by a single filtering. However, we have a solution for you.
Please see the below images and description.

First, iterate through the variations array and use an Array Aggregator. In between, we need to add a filter to check whether the text contains an item from the array or not, as shown below.

Finally, you can give a simple filter to meet your needs.

If there are matches the array length will always be greater than Zero.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
| Book Live Implementation
Visit us here
Youtube Channel

1 Like

Thanks for the reply! What is it that I should be aggregating?

Hi @AutomationNoob
You can select all or only the fields you require for further flow. Here is an example:

1 Like