Filter an item in array if it includes search term & get all the matches

[Laure]

I have a scenario to get records from an airtable table in one base and send them to another airtable base. I need to filter only the records containing the item “Convoyage” in a single select field.

I set up my scenario as show below but I can only get the first record in the table corresponding to the filter. Even if I have other records with the item “Convoyage”, they do not pass the filter.
I need some help to modify the scenario so that all the records with the item “Convoyage” get recorded in the other airtable base. (the modules 25 and 26 are the ones concerned)

I am a beginner and I thank you very much in advance for your help.

Module 25:

Filter:

Module 26:

[Msquare_Automation]

Hi @Laure

Please try to use the filter to avoid Convoyage.

Or you can try iterate the array of Prestations and text aggregate that and use filter as like below.

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

[Laure]

Thank you so much for your help.

Your explanation is very clear.

Cheers!