Multi-Select Drop down based off of another selection

(0) Share

Report

Posted on by joel914823

557

I have a multi-choice drop down created with a list of possible training topics that a team member may need.

I have a Visible function when the line of business equals Save a Trip, Home Delivery , or Pharmacy Care Center AND Team member requires additional training equals

(DataCardValue32.Selected.Value ="Yes" && "Save a Trip" in DataCardValue20.SelectedItems.Value) || (DataCardValue32.Selected.Value ="Yes" && "Home Delivery" in DataCardValue20.SelectedItems.Value) || (DataCardValue32.Selected.Value ="Yes" && "Pharmacy Care Center" in DataCardValue20.SelectedItems.Value)

I have a list of training topics but they don’t all apply to each of the different lines of businesses (Save a Trip, Home Delivery, and Pharmacy Care Center) and in some cases it applies to two different line of business. How could I alter the drop down to hold above true and then only show the respective Title of the training topic based on the line of business selected.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Try this formula

If(DataCardValue32.Selected.Value = "Save a Trip", LookUp(TrainingTopics, Title = DataCardValue20.Selected.Value && LineOfBusiness = "Save a Trip").Title, If(DataCardValue32.Selected.Value = "Home Delivery", LookUp(TrainingTopics, Title = DataCardValue20.Selected.Value && LineOfBusiness = "Home Delivery").Title, If(DataCardValue32.Selected.Value = "Pharmacy Care Center", LookUp(TrainingTopics, Title = DataCardValue20.Selected.Value && LineOfBusiness = "Pharmacy Care Center").Title, "" ) ) )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
joel914823 557 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Rajkumar_404 and to confirm I would put this within OnVisible or within Items?

Was this reply helpful? Yes No