How do I create a filter on an array?

Hello !

I’m looking to realize an filter between 2 modules (one notion and one slack module).
I need to filter slack messages which contained certains slack users as repliers.
Until now, I used a text operator / match pattern with the UID of the slack user on this array to see if one of these users has replied.

Since few days, it did not work anymore… Do you know how I can filter on these multiple values ? Thx !

Welcome to the Make community!

What is the value of {{4.`Reply users`[]}} ?

Please provide the output bundles of the module [4] by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Screenshot_2023-10-06_141025

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

2 Likes

hello @samliew
Here is an example of a bundle containing values for Reply users :

“reply_users”: [
“U04QYL7D7SS”,
“U03P9PPRAS1”,
“U034X97MSKY”
],

Here’s how I might do it.

  • Normalise the array into a single string (pipe-delimited)
  • Add pipes at the start and end
  • Use a similar pattern with the same symbol outside of the brackets (in this case, a pipe) to ensure a full match of each ID

Screenshot_2024-01-30_090144

\| is an escaped pipe symbol (because it’s using a regex)

3 Likes

Hello @samliew Thx you for your time, I’m really appreciated :slight_smile:
However, I tried your solution and it does not work :confused:
I have finally found the correct solution. Certainly the absence of “case insensitive” in the text operators was the origin of the error.

image

1 Like

Hello @Michael_Bastien :wave:

Awesome work figuring this one out and thanks a lot for sharing what did the trick with the rest of us :muscle:

1 Like