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.
Solved! Go to 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
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
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
User | Count |
---|---|
260 | |
110 | |
89 | |
52 | |
44 |