web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown dependencies ...

Power Apps

Answered

Dropdown dependencies filter from Sharepoint Choices

(0) Share

Report

Report

Posted on by nagestiada

504

Hey guys,

I have two dropdowns one is 'Product Type' and the other one is 'Product'

The 'Product' is in single line while 'Product Type' is Choice

so on my first dropdown the user should choose what Product Type

Sort(Choices(ProductMasterList.'Product Type'),Value,Ascending)

So on the 'Product' dropdown I want items to be filtered by the chosen product type. I am trying something like this but does not work.

Distinct(Distinct(Sort(Filter(Choices(ProductMasterList.'Product Type'),Value = ProductDrpDown.Selected.Value),ID,Ascending),Product)

Any help would be appreciated. Thank you!!!

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nagestiada ,

Try the below - the With() statament is only for Delegation management (a pre-filter)

With( { wProdType, Sort( Filter( ProductMasterList, Product = ProductDrpDown.Selected.Value ), ID ) }, Distinct( wProdType, Product ).Result )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Join the conversation