Sheet Action Select Values in a Field

[justalkak]

Hi,

I need to create a sheet action on sheet1 on FieldA where the values of FieldA1 from another sheet will be selected.

I have achieved it by setting the following Actions:

1. Select values in a field - on a FieldA - with function: Concat(distinct FieldA1, ';')

2. Clearing selections in FieldA1

This works, however when no FieldA1 is selected it filters for ALL FieldA options when moving to sheet1.

How can I make it not select All FieldA options when no FieldA1 is selected?

I have tried this but it won't work.. If(GetSelectedCount(FieldA1)>0, Concat(distinct FieldA1, ';'))

[henrikalmen]

Are all values actually selected in FieldA, or are no values selected so that all values are implicitly available? 

[justalkak]

No values are selected in FieldA1. Then when changing the sheet All values are selected by the action on FieldA.