cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baldursgate22
New Member

Multicascading Dropdown filters with choice type fields in Sharepoint List

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":

 

UOStatoColor
UO1In lavorazioneGreen
UO1In lavorazioneRed
UO2In lavorazioneBlue
UO2CompletatoGreen


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?

1 ACCEPTED SOLUTION

Accepted Solutions
baldursgate22
New Member

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.

View solution in original post

1 REPLY 1
baldursgate22
New Member

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,277)