How to use SetControlValue to include Blank?

Desired end state: use a button to get it to the image.png 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

:waving_hand: @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

trickyyyy, thank you!

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