web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering a Combobox b...

Power Apps

Answered

Filtering a Combobox based on another combobox data

(0) Share

Report

Report

Posted on by Rudy_Digital

114

Hello all,
I have the following situation:

I need to have:

1. In the ComboBox1 results I should see only MT1, MT2, MT3, etc… (Distinct values)

2. In the ComboBox2 results, I want to have all distinct Sub Topics related to the Main Topics
for example: IF ComboBox1 = MT1, then ComboBox2 = dropdown list of ST1, ST2, ST3.

3. In the ComboBox2, i want to let the option for the user to type in another data (for example ST35) and Combobox1 = MT2 and therefore updates the SPList with a new record of MT2 in Main Topic Column and ST35 in the Sub Topic Column.

Thanks for helping 🙂

Would be an easy one for your guys 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Rudy_Digital,

Do you want to add options in the ComboBox2 and save back to data source?

If so, here is a simple demo for your reference.

1). Set the Items property of ComboBox1 as:

Distinct(TOPIC,'Main Topic')

2). Set the Items property of ComboBox2 as:

Filter(OPIC,'Main Topic'=ComboBox1.Selected.Value).'Sub Topic'

3). Add a save button and set OnSelect as:

Patch(TOPIC,Defaults(TOPIC),{'Sub Topic':If(IsBlank(ComboBox2.Selected),ComboBox2.SearchText,ComboBox2.Selected.Value)})

Was this reply helpful? Yes No

Join the conversation