cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dobroo
Resolver I
Resolver I

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuxima-msft
Community Support
Community Support

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

20190205savecomboboxselectvaluesapp1.jpg

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

20190205savecomboboxselectvalues2.jpg

Result Test:

20190205savecomboboxselectvalues1.gif

 

Hope this can be helpful.

Best Regards.

Yumia

View solution in original post

2 REPLIES 2
v-yuxima-msft
Community Support
Community Support

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

20190205savecomboboxselectvaluesapp1.jpg

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

20190205savecomboboxselectvalues2.jpg

Result Test:

20190205savecomboboxselectvalues1.gif

 

Hope this can be helpful.

Best Regards.

Yumia

Hi Yumia,

 

this is more than helpful Smiley Happy

 

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

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,906)