Combo Box

(0) Share

Report

Posted on by omi18

640

Hello People,

I'm trying to build a searchable combo box. I have 2 combo boxes.

Scenario: Let's say, I am selecting Semester from the first combo box. and for the second combo box, I am filtering the students based on the selection of the first combo box.

I want to make second combo box searchable for the student name.

I'm using SQL Server as a data source.

Thanks,

Omi

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

In your combobox1 items property put:
Datasource.semester

In the second combobox put;
Filter(Datasource, Semester=combobox1.Selected.Semester)

Watch these videos for further information;
https://youtu.be/pkZG2boN7jQ
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
DevendraSingh 144 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,
To make combo box searchable, enable the "Allow searching" property.
Please click Accept as Solution, if this solution solved your issue. If this post was useful, please consider giving it Thumbs Up.

Thanks & Regards,
Devendra Singh
omi18 640 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks, @eka24 ,

this is my current code for that combo box: Distinct(Sort(Filter('[travel].[CourseDesc]',Semester=First(SemesterBox_1.SelectedItems).Result),Descending),email1)

and if I allow search dropdown will not appear. And I allow search then nothing happens.

Best,
Omi
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

On the Onvisible of the screen put;
ClearCollect (MyCourse,'[travel].[CourseDesc]')

Then change the formula to;
this is my current code for that combo box: Distinct(Sort(Filter(MyCourse,Semester=First(SemesterBox_1.SelectedItems).Result),Descending),email1)

Then turn Allow searching
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
omi18 640 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @eka24

Thanks for your reply. But unfortunately, it didn't work. I'm wondering if I'm making a silly mistake. what do you think?

Best,
Omi
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I Suggest you show a screen shot of the sample tables showing the columns. Also indicate the name of the Table on combobox 1 and combobox1
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
omi18 640 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24 ,

It got resolved, thanks for your help.

Best,
Omi
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If it resolved, Mark my reply as a solution
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.