Answered

Comboboxes with filtered datasources

Like (0) Share

Report

Posted on 9 Aug 2018 19:53:49 by Community Power Pla...

Hello,

I've been trying to implement a cascading flow between two comboboxes. One is connected to a list of "parent" values, the other containing a filtered list of "child" values with a reference to its corresponding parent value via lookup column. This combobox should only contain choices tied to the parent values selected in a previous combobox. The lists are set up as follows:

However, whenever I place the following query into the subitem combobox the item collection returns empty or doesn't update from previous setting, while the same query seems to work for other controls such listboxes and dropdowns:

Filter(SubItemDemo, ParentItem.Value in ComboBox1.SelectedItems.Title)

In fact, the only filtering I can get working with the combobox is through simple compares with strings such as Title = "SubItem1". Any time I use operators such as <>, "in", or anything else that throws a delegation warning it stops updating or fetching data.

Is there anything I'm missing here?

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

v-xida-msft on 11 Aug 2018 at 09:07:29

Like (0)

Report
Re: Comboboxes with filtered datasources

Hi @Anonymous,

I have made a test and the issue is confirmed on my side.

I agree with @Drrickryp's thought almost. You could consider take a try to save your two SP list data sources as two separated collections within your app, and then use the two collections as data source within the two Combo box controls.

I have made a test on my side, please take a try with the following workaround:

Set the OnVisible property of the screen to following formula:

ClearCollect(ParentItemDemo,'20180811_case13_ParentItemDemo');
ClearCollect(SubItemDemo,'20180811_case13_SubItemDemo')

Note: The '20180811_case13_ParentItemDemo' represents the ParentItemDemo SP list on your side, the '20180811_case13_SubItemDemo' represents the SubItemDemo SP list on your side.

Set the Items property of the first Combo box control (ComboBox1) to following formula:

ParentItemDemo.Title

Set the Items property of the second Combo box control (ComboBox2) to following formula:

Filter(SubItemDemo,ParentItem.Value in ComboBox1.Selected.Title).Title

Best regards,

Kris
Drrickryp Super User 2024 Season 1 on 10 Aug 2018 at 17:21:06

Like (0)

Report

Re: Comboboxes with filtered datasources

Will it work if you create collections from your lists and use the collections as the datasources in the comboboxes instead of the original lists? Delegation does not apply to collections and you are not limited to the usual arithmetic operators (=, etc). Ref. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list