How to find Unique values from a Multiselect column?
You are right, Since Multiselect column will throw out data in a more complicated format, binding it straight to a list type control will not work.
You can use the following way to list out the unique values from a multiselect column:
Point to note here is that a function called as
FLATTEN() is used to first flatten the multiselect data into a list type data and then run
UNIQUE() on top of it.
Hope this helps.
P.S: Since we are also Beta testing a feature to write your own
FUNCTIONS() do let me know if you would like to test run the same and build magical Formulas and Functions.