How to exclude empty or false values from add() when building a Notion multi_select?

Questions
, , ,
1

Hi everyone,

I’m trying to build a multi_select array to send to a Notion database via Make. Here’s what I’m doing

{{add(
emptyarray;
if(contains(join(1.categories; " | "); “user/1005224376/label/Partners”); “Partners”; " ");
if(contains(join(1.categories; " | "); “user/1005224376/label/Competitors”); “Competitors”; " ")
)}}

The idea is to include a value only if a condition is true.
If the condition is false, I don’t want to include anything at all — not an empty string, not null, not {} — literally nothing should be added to the array.

So far, I’ve tried:

  • Using "" or " " → it adds an empty string as a value in Notion

  • Using {} or null → it breaks the scenario or causes errors in Notion

  • Skipping the else part in if() → Make returns an error

    image
    image759×138 13.6 KB

What’s the proper way to exclude a value entirely from add() when a condition is not met?

Thanks a lot for your help!

3

Hi Clément, see if the “Remove” function as explained here works for you - Delete/remove empty data row within an array

1 Like