I have created a Sharepoint List with 2 columns which are 2 choice type fields:
This is my origin data Sharepoint list which I called "Cabine":
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:
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?
Go to 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.
View solution in original post
Keep up to date with current events and community announcements in the Power Apps community.
Check out the latest Community Blog from the community!