Multicascading Dropdown filters with choice type fields in Sharepoint List

[baldursgate22]

Hi everyone,

I have created a Sharepoint List with 2 columns which are 2 choice type fields:

• UO column = with 2 possible choices:
  - UO1
  - UO2
• Stato column = with 2 possible chioices:
  - In lavorazione
  - Completato

This is my origin data Sharepoint list which I called "Cabine":

UO	Stato	Color
UO1	In lavorazione	Green
UO1	In lavorazione	Red
UO2	In lavorazione	Blue
UO2	Completato	Green

What I'm gonna do now is creating 2 dropdown cascading filters.

So I created:

-DropdownUO = in the "Items" field I wrote this line of code:

Choices(Cabine.UO)

and it works. I can choose between UO1 or UO2.

-DropdownStato = in the "Items" field I wrote this line of code:

Distinct(Filter(Cabine; UO = DropdownUO.Selected.Value); Stato)

and I can't visualize the possible choices. It's blank and the choices don't appear.

I also tried to update my data origin but it's the same.

Please could you help me to figure out?

[baldursgate22 · Accepted solution]

Ok I got on my own the solution.

You need to write this line of code in Items field of the DropdownUO:

Filter(Distinct(Cabine; UO.Value); !IsBlank(Result))

And this one in Items field of the DropdownStato:

Distinct(Filter(Cabine; UO.Value = DropdownUO.Selected.Result);Stato.Value)

I hope this will help someone.