Hi everyone,
So, I have a dropdown in which I select a single option for both and a Combobox that displays some results that depend on the selected item of the dropdown. In ths combobox I can choose several items but I have an issue trying to Concat and save it into a Collection. All the information comes from a Sharepoint List called "Geografia".
My dropdown contains the next formula in it's Items property:
Sort(Distinct('Geografia';Nombre);Result)
While the Combobox looks quite different:
Distinct(Filter('Geografia';Region=Dropdown.Selected.Result);Centro))
The issue is that if I set a label with the following formula:
Concat(ComboBox.SelectedItems;",")
The result looks like this: , , ,
Solved! Go to Solution.
That sounds like good progress! At this point, you should be able to recombine your formula like so.
In the formula, I would also make sure to spell "Value" with a capital V, because it'll be case sensitive when you refer to the selected items in your call to Concat.
If(!IsBlank(DD_Zona_5.Selected.Result);
AddColumns(
Distinct(Filter('Geografia';Region=DD_Zona_4.Selected.Result);Nombre_Centro));
"Value";
Result.Value
);
Choices([@'Geografia PD'];Nombre_Centro)
)
Hi @Knight23
Can you try the following to see if that works better for you?
Concat(ComboBox.SelectedItems; Centro & ",")
Hi @timl ,
I tried as you mentioned but I get the next message:
"Invalid name. Cannot recognize the identifier. This error appears when a formula references an element that no longer exists"
I also tried using Thisitem.Centro and ThiRecord as they're listed in the options and I get the following error:
"Invalid argument. One of the following was expected: Text, Number, Boolean, OptionSetValue, ViewValue."
My combobox is set inside a gallery and the source Sharepoint column is a list of options
Hi @Knight23
Thanks for clarifying this. Does this work any better?
Concat(ComboBox.SelectedItems; Result & ",")
Doesn't seem to work either 😞
I get the same "invalid name/unknown identifier" message.
Hi @Knight23
So that we diagnose this further, can you store the results in a collection so that we can see the column headers?
To do this, add a button inside your gallery where your combobox is and set the OnSelect property to the following:
ClearCollect(colTest; ComboBox.SelectedItems)
If you select some items in your Combobox and click the button, can you view the colTest collection in the File > Collections menu, check that it contains the items that you expect, and post a screenshot of what you see here?
Interesting, I selected 5 items in the combobox, collected them as you suggested and the result is as follow:
There's no collection at all.
That's useful because that explains why your call to Concat doesn't work!
The next step is to work out why this is showing up as empty. Can you confirm that ComboBox is definitely the name of the combobox in your gallery?
Yes! Combobox is definetly the name of my combobox.
In your label, if you type the following...
First(ComboBox.SelectedItems).
can you confirm or screenshot the column name suggestions that appear in the formula bar after the dot symbol?
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
256 | |
254 | |
83 | |
40 | |
30 |
User | Count |
---|---|
311 | |
265 | |
122 | |
65 | |
48 |