Cascading ComboBox only returning the first match?

(0) Share

Report

Posted on by simms7400

829

Hi Folks -

I have a cascading ComboBox setup but it's only returning the first match value. Allow me to explain:

I have a ComboBox setup where a user will select a value (Project Alias). This ComboBox has a data-source of a Collection, easy setup here no issues.

Then, based on THAT (Project Alias) selection, I want to display only the child data element(s) that roll-up to it in the ComboBox Activity Alias. Activity Alias has a collection data source called ActivityTree that is as in the following format and contains all possible combination:

The Activity Alias ComboBox is set to display "Alias" (see above). Therefore, in my Items property of the Activity Alias ComboBox, I have the following formula:

Filter(ActivityTree, Parent_Alias = IOInvestmentAliasCB.Selected.Alias)

So my thoughts are that it will return ALL records from the "Alias" column that match the "Parent_Alias".

As you can see, it's only returning the first record:

However, when I click on the Activity Alias dropdown, it's only displaying 1 record:

Did I set something up incorrect?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

GarethPrisk 2,828 on at

Like (0)

Report
Your formulas and configuration appear to be correct. In theory, that should return all the rows in your screenshot for that particular ComboBox.

A few questions/considerations:
You are using a Form control - which implies it is using (or was setup using) fields from a Source
Did you collect the Data Source into a Collection, and now the Form's DataSource is the Collection?
Did you customize the Combo Box field from the source to point to the other Collection instead of the source's field?
What is the Default property for that card's (Combo Box) input?
Is Activity Tree a source or a collection? Your phrasing implies it is a Collection from a data source, but want to confirm
Is IOInvestmentAliasCB that visible Project Alias card? Is the Alias property the same as what as is visible?

Was this reply helpful? Yes No
simms7400 829 on at

Like (0)

Report
A few questions/considerations:
You are using a Form control - which implies it is using (or was setup using) fields from a Source
Did you collect the Data Source into a Collection, and now the Form's DataSource is the Collection?
I'm using both. All of the fields are using a SharePoint list as the source. However, I added both of the ComboBox to the (2) DataCards and link the field to the selected value and then placed the ComboBox over the original field.
Did you customize the Combo Box field from the source to point to the other Collection instead of the source's field?
Not sure what ComboBox you are referring. However, "Project Alias" field (IOInvestmentAliasCB) uses a collection as source. "Activity Alias" field (IOActivityAliasCB) uses a different collection as a source. But, the "Alias" values for Project Alias do exist as the "Parent_Alias" in the Activity Alias Combobox collection.
What is the Default property for that card's (Combo Box) input?
The default propeties for each ComboBox are variables which contain selections fro previous screens. Think about a hierarchy, the current forms I am displaying is the lowest level and the PowerApps application I have setup forces the user to selection the "Grandparent" which is the "Project Alias". I have set that gallery selection is a variable and thus using it in the Default field here. Next, the user will navigate to the next form, which is the "Parent" of the current form and makes another selection. That is also captured in a variable and used in the Default properties of "Activity Alias".
Is Activity Tree a source or a collection? Your phrasing implies it is a Collection from a data source, but want to confirm
It is a collection. See my table above. I collect that exact table. It shows as an MS Access table but it's really a SharePoint List.
Is IOInvestmentAliasCB that visible Project Alias card? Is the Alias property the same as what as is visible?
IOInvestmentAliasCB is Project Alias, yes. It's the ComboBox i have overlayed into that card. And yes, I'm displaying the Alias property.
Thank you for your help!!!!!

Was this reply helpful? Yes No
simms7400 829 on at

Like (0)

Report

@GarethPrisk

To make it simpler, I have the SAME source (Collection) for both ComboBox's now. This should make triaging easier as I'm still unfortunately getting the same result.

Was this reply helpful? Yes No
Verified answer

simms7400 829 on at

Like (0)

Report

Please ignore. This seemed to be an issue with one of my collections. It's all fixed now.
I actually had to not use the dependency feature and just filter Combo Box 2 based on the selection of ComboBox1.

Thank you!

Was this reply helpful? Yes No