web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Multicascading Dropdow...

Power Apps

Answered

Multicascading Dropdown filters with choice type fields in Sharepoint List

(0) Share

Report

Report

Posted on by baldursgate22

9

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?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

baldursgate22 9 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Join the conversation