web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Conditional Filtering ...

Power Apps

Answered

Conditional Filtering in the Items of a dropdown input?

(0) Share

Report

Report

Posted on by cmnflom

18

I know that it's possible to filter a gallery based on a dropdown, but I wanted to know if it is possible to do the opposite as well?

I have a gallery where users will go and update two columns of each row by using a dropdown.

My question is, can you filter what appears in the Items of each drop down based on what the selected row's "Item Type" is?

I was thinking of doing this by creating a collection and putting that in the Items of each dropdown - but that keeps giving me errors. How can I create conditional filtering within the dropdown Items?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@cmnflom

Yes this can be done. First, skip the collections and just put it in your Dropdown Items property.

ex. with static values:

Switch(ThisItem.ItemType, "ItemA", ["Option1", "Option2", "Option3"], "ItemB", ["OptionY", "OptionZ"] //...etc... )

With Dynamic Values:

Switch(ThisItem.ItemType, "ItemA", Choices([@someListA].SomeColumnA]), "ItemB", RenameColumns(Distinct(someListB, SomeColumnB), "Result", "Value") "ItemC", RenameColumns(Filter(SomeListC, SomeCriteria=SomeCriteria).SomeColumnC, "SomeColumnC", "Result") //...etc... )

The options are endless!!

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation