Share
ReportHello. Does anyone know how to split Dropdown values? All three values come from 3 different columns.
Thanks!
Categories:
You’re offline. This is a read only version of the page.
Hello. Does anyone know how to split Dropdown values? All three values come from 3 different columns.
Thanks!
Hey @stayclassy ,
I understand what you are trying to do. You could replace it with a collection:
All responses (
Answers (
ForAll(
Filter(
TableName,
ColumnName=DatacardValue43_1.Selected.value
),
Collect(colResult,{Value:Column1});
Collect(colResult,{Value:Column2});
Collect(colResult,{Value:Column3})
)
Like this you will have a table with one column as result. you can than use it in a Dropdown, Combobox or in a gallery with buttons for example.
Without concatenate, it doesn't work at all. I've already tried. I must be doing something wrong.
My DropDown is located within an EditForm (Table X). I perform a filter on Table Y there. If DataCardValue43_1.Selected.Value (from Table X) is equal to ColumnZ (Table Y), list the values from columns A, B, and C.The values are listed only when I add Concatenate, but that's not a solution. The user must be able to select only one value from all the options offered.
Hey @stayclassy ,
yes you can split it with the split function
Split(Dropdown.Selected.Value,"-") // "-" is the seperatoryou'll get than a table with 1 column with the data in it.
You could also just not Concatenate it.
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,011
Most Valuable Professional
