Dynamic dropdown linked to gallery columns

[troc]

Hi all,

I don't know if it is possible to develop this but I am convinced that this forum will help me to find out a solution.

I have a collection with 4 columns (named for example: A, B, C, D).

On the other hand, I have two dropdowns:

- The first one should let me choose one of those columns (A, B, C or D). This step is done, adding in "Item" this list [A, B, C or D].

- The other one, would filter the collection by the column selected in the first one.

So if I choose in the first dropdown "C", in the next dropdown I could filter the collection/gallery by column C values.

It is that possible to do?

Many thanks!

[mmollet]

Dropdown1.Items -> ["A", "B", "C", "D"]

Dropdown2.Items -> Filter(CollectionName, ColumnName = Dropdown1.Selected.Value)

if you want only distinct values (no duplicates in your ColumnName column) then add distinct call to front.

Dropdown2.Items -> Distinct(Filter(CollectionName, ColumnName = Dropdown1.Selected.Value))

[TheRobRush]

Switch(
      dropdown1.selected.value,
      "A",
      Filter(MySource, ColumnA = "What it needs to equal"),
      "B",
      Filter(MySource, ColumnB = "What it needs to equal"),
      "C",
      Filter(MySource, ColumnC = "What it needs to equal"),
      Filter(MySource, ColumnD = "What it needs to equal")
)

[troc]

Hi,

Thanks for your solutions @TheRobRush and @mmollet but unfortunately both of them didn't work to me.

I have tried with this but also didn't success:

1. In "On Change" I have created one variable for each column:

Set(varA; Concat(collection; A; ";"));;
Set(varB; Concat(collection; B; ";"));;
Set(varC; Concat(collection; C; ";"));;
Set(varD; Concat(collection; D; ";"))

2. In "Items" I call each variable through this switch, similar to @TheRobRush solution:

Switch(Dropdown.Selected.Value;
"A"; Filter(collection; A = varA);
"B"; Filter(collection; B= varB);
"C"; Filter(collection; C= varC);
"D"; Filter(collection; D= varD)
)

This option returns one warning which says "incompatible types for comparison. These types cannot be compared: Number, Text". Any ideas how to solve it?

[TheRobRush]

Dropdown.Selected.Value

Put that in a label and see what it gives you 

[troc]

I see the value returned by the Dropdown (A, B, C, D).

Now, I want to use this value in other dropdown to filter my collection by A, B, C or D column.  

[TheRobRush]

So I wanted to be sure, but can now verify it's not the format of the code I gave you as I set up a test on my side in same basic layout and it is working lovely

Switch(Dropdown1.Selected.Value,
"A", Filter(EventMaster, Title = TextInput5.Text),
"B", Filter(EventMaster, SchoolName= TextInput5_1.Text),
"C", Filter(EventMaster, SchoolBarcode= TextInput5_2.Text),
Filter(EventMaster, EventDate=DatePicker4.SelectedDate)
)

Since your dropdown is giving a letter properly ( we tested this via the label thing ) I would next put varA, varB, varC, varD in labels and make sure they are returning proper results, and then move on to checking my column types in sharepoint to ensure they are set properly (string vs number etc), and if all else fails go to the list settings (gear in upper right, then click list settings) then on settings page click on each of these columns one at a time, then look in your address bar at top of screen and see what follows the = symbol, if it is different than the A B C D you have written here in your formula change it to whatever is there, an example below

sometimes that is diffferent if things changed after initial setup

[troc]

Hi all,

I am trying again to develop this feature in my app through those components:

• Dropdown1.Items -> ["Id", "Name", "Description”]

Dropdown1.OnChange -> 

Set(drpdwn1;

    Switch(

        Dropdown1.Selected.Value;

        "Id"; Distinct(collection_name;Id);

        "Name"; Distinct(collection_name;Name);

        "Description"; Distinct(collection_name;Description)

    )

)

• Combobox1.Items -> drpdwn1

I need to filter my collection by the Combobox Item selected, but I can’t. Using ComboBox1.SelectedItems returns a table and I do not know how to manage. Anyone to help me, please?