Hello Everyone,
I have some excel data that I would like to concatenate and then populate a dropdown menu. I have been trying it with the following code, but my new column shows up empty.
ClearCollect(Collection, Table1);
Collect(Collection,{NewColumn: Concatenate(Collection.ID," - ", Collection.Title)})
And when I try to populate the dropdown menu i get the following warning
Do any of you have any tips?
Would certainly be greatly appreciated.
Solved! Go to Solution.
Hi @ToFj ,
Are you trying to add a new column to your collection ? If so, please use this formula:
ClearCollect(Collection,
AddColumns(Table1,"NewColumn", ID & " - " &Title)
)
Now the collection is ready to be used inside items dropdown. Don't forget to set value property on the right menu.
Hope it helps!
Hi @ToFj ,
Are you trying to add a new column to your collection ? If so, please use this formula:
ClearCollect(Collection,
AddColumns(Table1,"NewColumn", ID & " - " &Title)
)
Now the collection is ready to be used inside items dropdown. Don't forget to set value property on the right menu.
Hope it helps!
User | Count |
---|---|
174 | |
115 | |
86 | |
44 | |
41 |
User | Count |
---|---|
238 | |
150 | |
132 | |
77 | |
73 |