Answered

Cascading dropdowns based on choice columns in SharePoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community,

I am getting dropdown values for Function using Choices(BRD.Function). The result shows "Recruitment" in the image below.

The control name is Dropdown1_2

Now, i want to cascade the value selected in this dropdown "Function" to bring cascaded values for another dropdown1_1 for Status. The value of status is Active, Inactive, Under-Development- but my function is failing

Choices((Filter(BRD,Function.Value=Dropdown1_2.Selected.Value)).Status)

This above formula is not working as is show in the error on the right and this is also affecting my table filtering formula below

Based on these 2 dropdowns- i am filtering my table below with

Filter(BRD,Status.Value=Dropdown1_1.Selected.Value,Function.Value=Dropdown1_2.Selected.Value)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Vijay Tailor 2,961 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

if you using cascading Drop down the don't use the CHoices in the second drop-down where you need to filter data based on the first dropdown.

Directly you can use Filter command and Set thee mapping into value Property.
Like below.
Filter(TestAkshay,Title=Dropdown3.Selected.Title)
Mapping for Value Property - (Select the field you want to DIsplay in the drop-down from the list in value property )

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@VijayTailor It doesn't work because i have both these columns "Function" & "Status" set-up as Choice columns in my SharePoint list.
And on the dropdown you showed- it doesn't even show my complex type columns- see the screenshot below
That is why i was forced to use Choice formula

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

FIne , if you hve complext type column then you can use like below.
AddColumns(Filter(TestAkshay,Title=Dropdown3.Selected.Title),"StatusValue",Complexity.Value)

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No