Answered

combo box not showing all values

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

i am creating an app which shows a list of students and what course they do, i have a combo box which filters the students depending on what course you select.

however when no course is selected the gallery is empty, i need it so that it shows all the students and then as courses are selected in the combo box it filters the out the students who don't do that course.

here is the code in my gallery

Filter('ExpoTees.Student', sstudents.Text in StudentName && CourseID in CourseCombo.SelectedItems.CourseID)

this also includes the code to enable them to search the students name which is a seperate text input which does work.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

PTBBSolutions 691 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

By the look of your code it seems that the gallery behaves exactly as it should. If you want see all record when nothing is selected, you have to add an If condition:

If(IsBlank(sstudents.Text) And IsBlank(CourseCombo.SelectedItems.CourseID), 'ExpoTees.Student',Filter(.....))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have added this code and it’s now come up with loads of errors, it’s now got errors near the students image, students name and the students course on the gallery.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

please try this code:

If( IsBlank(ourseCombo.SelectedItems.CourseID) && !IsBlank(sstudents.Text), Filter('ExpoTees.Student', sstudents.Text in StudentName), !IsBlank(ourseCombo.SelectedItems.CourseID) && !IsBlank(sstudents.Text), Filter('ExpoTees.Student', sstudents.Text in StudentName && CourseID in CourseCombo.SelectedItems.CourseID), !IsBlank(ourseCombo.SelectedItems.CourseID) && IsBlank(sstudents.Text), Filter('ExpoTees.Student',CourseID in CourseCombo.SelectedItems.CourseID), Filter('ExpoTees.Student', sstudents.Text in StudentName && CourseID in CourseCombo.SelectedItems.CourseID) )

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

ive put this in and the gallery is still blank

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

Maybe you could try this formula

If( IsBlank(ourseCombo.SelectedItems.CourseID) && !IsBlank(sstudents.Text), Filter('ExpoTees.Student', sstudents.Text in StudentName), !IsBlank(ourseCombo.SelectedItems.CourseID) && !IsBlank(sstudents.Text), Filter('ExpoTees.Student', sstudents.Text in StudentName && CourseID in CourseCombo.SelectedItems.CourseID), !IsBlank(ourseCombo.SelectedItems.CourseID) && IsBlank(sstudents.Text), Filter('ExpoTees.Student',CourseID in CourseCombo.SelectedItems.CourseID), 'ExpoTees.Student' )

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

it worked but then when i cleared the filters i added it went blank again

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous :

If you have new questions, I suggest you create a new thread.If so, you can get help from many people to solve the problem in time.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

it worked for a second but when i cleared the filters in the combo box the gallery went blank again

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

Sorry, the formula I provided doesn’t seem to be complete, please try this formula

If( IsBlank(CourseCombo.Selected) && !IsBlank(sstudents.Text), Filter('ExpoTees.Student', sstudents.Text in StudentName), !IsBlank(CourseCombo.Selected) && !IsBlank(sstudents.Text), Filter('ExpoTees.Student', sstudents.Text in StudentName && CourseID in CourseCombo.SelectedItems.CourseID), !IsBlank(CourseCombo.Selected) && IsBlank(sstudents.Text), Filter('ExpoTees.Student',CourseID in CourseCombo.SelectedItems.CourseID), 'ExpoTees.Student' )

Best Regards,

Bof

Was this reply helpful? Yes No