The property expects Text values, but this rule produces incompatible Table values.

[dobroo]

Hi Experts,

I get the error "The property expects Text values, but this rule produces incompatible Table values."

The setting:

List1

Name               status

A1                    active

A2                    none

A3                    active

...                      ...

List2

Names                ColumnA                ColumnB

A1, A2                 "TextA"                   "TextB"

A2, A6, A9           "TextC"                   "TextD"

...                         ...                             ...

I have 2 Lists. In List1 are the names (column1) and the status (column2)

In List2 I wanna work with a customized form. In List2 the Combobox1 -> Items I use the function 

Filter(List1;status=Lower("active")).Title

I wanna filter all the listings "status = active" of List1.

Now if I select more than 1 choice only the last selected value being registered in list 2. In DataValueCard -> Update is the function 

Combobox1.Selected

If I change the entry in Combobox1.SelectedItems I get the error above.

How can I transfer more than 1 entry to List2 of the choices with the filter-function.

Any help will be greatly appreciated.

Thanks, Olli.

[v-yuxima-msft · Accepted solution]

Hi @dobroo,

Do you want to update the combo box’s select items into the Names Column?

 For your Formula Combobox1.SelectedItems you are referring to a table of records not values, so you need to still reference which value(Column) from each record you want as a result.

So you can changes the Names Data Card’s Update: Concat(ComboBox1.SelectedItems,TextName&",")

App Test:

 Combo box1.Items: Filter('20190201TextValue1',Status.Value="active").TextName

Names_DataCard1.Update: Concat(ComboBox1.SelectedItems,TextName&",")

Result Test:

Hope this can be helpful.

Best Regards.

Yumia

[dobroo]

Hi Yumia,

this is more than helpful 

Now I understand the formula Concat() and I can use it.

Another help was that I checked the property "multiple selection" of the column. I had missed this.

But now I understand the function of Concat() and can work with it. Thanks a lot.

Best regards 

Olli