Combobox - show values from two column, but refer to one of them

(0) Share

Report

Posted on by knyklu

153

Hi,

I need to show values from two column in combobox - no problem.

But how can I refer to only first value,

IE. Source of CB with multiselect on.

Distinct(Filter(Table; IsBlank(ColSample) || IsEmpty(ColSample) || Column1 in ColSample);Column2&" "&Column3)

In gallery source I want to refer only to Column2, and I can do that by:

ColumnX = First(Split(CB.Selected.Value;" ")).Value

Problem is, I want to refer by 'in' operator, but I can't, because In need a table (CB.SelectedItems).

Any tips?

Categories:

All responses (1)

Answers (1)