Answered

Show choices based upon on other field selection from sub list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

i want to show "Commodity Code" field dropdown based on the "cost type" field selection

As you can see from the below screenshot ,I have two field with values in sub list, which i have used as dropdown in the main list.

I was able to get the dropdown in the app, I used distinct Value from cost type field and when user selects Cost Type from dropdown I want show values in commodity code dropdown which is based on cost type selection.

If user selects Advertising in cost type dropdown, then first 3 value in community code should show in dropdown i.e. direct to consumer, advertising production, hcp advertising.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

WarrenBelz 155,495 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

This should do it

Sort( Filter( OBUCostTypeGLMapping, CostType = YourCostTypeDD.Selected.Result ).CommundityCode, CommundityCode )

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz thank you so much for the help, it resolved the issue

Was this reply helpful? Yes No