Search code examples
filtercomboboxpowerapps

PowerApps combobox filter from another combobox

I have a number of combo boxes on a screen and they all use the same source "Table1" from an external excel sheet).

When I have selected a value from "Combobox 1" I would like it not to be available for selection in the other combo boxes... following on and on as items are selected.

I am very new to PowerApps and this is my first app. I have tried to filter...

filter(Table1 <> ComboBox2.Value) but receive the red cross.

If you could help me with the syntax for this that would be great.

Thanks

Will

Solution

  • For this I had to build a collection which is added to by all the combo boxes with a remove when unselected also with the below syntax...

    RemoveIf(COLLECTIONNAME,Dropdown = 1); Collect(COLLECTIONNAME,{COLUMNNAME FROM COLLECTION:Self.Selected.Team,Dropdown:1});

    Then the items had to be where not in the collection with the following syntax...

    Filter(Table1, !(COLUMNNAME FROM TABLE 1 in COLLECTIONNAME.COLUMNNAME FROM COLLECTION))

    Thanks for all the suggestions, hope this helps someone