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:
While the Combobox looks quite different:
The issue is that if I set a label with the following formula:
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 @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
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:
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?
In your label, if you type the following...
can you confirm or screenshot the column name suggestions that appear in the formula bar after the dot symbol?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.