Check if Canvas Multiselect list contains 'Blank'

1

Hi team,

Quick Question
Does anyone know how to detect if ‘Blank’ is selected in a multiselect drop down?

I have a multiselect drop down that I use for filtering and some fancy formulas.
It is useful to be able to filter items that are ‘Blank’ so I have turned this option on.
image

However, there does not appear to be anyway to tell by formula if the mutliselect drop down ‘Contains’ blank.
For example:
image

MultiSelect = []
MultiSelect.ToText() = ""
MultiSelect.count() = 0

This is should be different then if no value is selected at all.
image

MultiSelect = []
MultiSelect.ToText() = ""
MultiSelect.count() = 0
2

Hi @Logan_Krantz

Can you share a dummy doc?

Otherwise please check the doc below and let me know if it it was you wanted.

2 Likes
3

Hi Christian,
Wow, thats it! It was so simple!
Thanks!

SwitchIf(
  [multiple select 1].Contains(""),
  "Blank is selected",

  [multiple select 1].IsBlank(),
  "Is empty",

  "Not empty"
)

Also if anyone else comes across this post I reaslised the .CountAll() function is also very useful. E.g.
image

MultiSelect.Count() = 0      // Counts non blank values
MultiSelect.CountAll() = 1   // Counts all values including blank
1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.