Desired end state: use a button to get it to the
status, or at least to include all options, including Blank
I’ve seen:
I think this used to work, but it doesn’t seem to work anymore:
[relation].SetControlValue(Table.ListCombine(''))
Here’s a doc demoing the bug
1 Like
@ConnorMcCormick
in relation settings - set the “starting value” to select all (including the blank), then use the ResetControlValue() formula
cheers!
Mel
2 Likes
Hi @Melanie_Teh! Thank you so much for the response!
This works for select lists
multi select list with select list set to all: ,A,B,New Add all [select 3].ResetControlValue()
But doesn’t work for multi select list that references a table, nor for relation types. Do you know of a way to do it with those?
1 Like
@ConnorMcCormick
Set the blank first in formula before the table?
2 Likes
Ah wait, hmm, no that doesn’t work. Seems that if it’s a Collaborative type select list then there’s no Starting value option:
1 Like
Put “Table” in selectable items
1 Like
No, I mean the option for a starting value isn’t even available.
1 Like