Multi Select Combo Box Gallery Filter Problems

(0) Share

Report

Posted on by SamanthaLavoie

161

Hello,

I added a multi-select combo box drop-down filter to a gallery that I already had multiple single select dropdown filters on, which were working fine, but nothing is working now that I've added the combo box to it. This is my first time using a multi-select combo box and I can't figure out what's wrong with the code. I'm hoping someone can help me out.

The Item property of my gallery is currently:

SortByColumns(
Filter(
'WORK LOG',
StartsWith('Contractor Name', SearchBoxCONTRACTORNAME_1.Text) &&
StartsWith('Contract Number', SearchBoxCONTRACTNUMBER_1.Text) &&
(DropdownCOSLead2.Selected.Value=Blank() || 'COS Lead'=DropdownCOSLead2.Selected.Value) &&
(DropdownProcessingStatus_1.Selected.Value=Blank() ||'Processing Status'.Value=DropdownProcessingStatus_1.Selected.Value) &&
(DropdownDIVISION_1.Selected.Value=Blank() || Division=DropdownDIVISION_1.Selected.Value) &&
(DropdownCOSSpecialist_1.Selected.Value=Blank() || 'COS Specialist'=DropdownCOSSpecialist_1.Selected.Value) &&
(ComboBox2.SelectedItems.Value=Blank() || 'COS Specialist1'.Value=ComboBox2.SelectedItems.Value)

"Modified",
SortOrder.Descending
)

Thank you in advance to anyone who can help!

Samantha

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SamanthaLavoie

Try this formula,

SortByColumns(
Filter(
'WORK LOG',
StartsWith('Contractor Name', SearchBoxCONTRACTORNAME_1.Text) &&
StartsWith('Contract Number', SearchBoxCONTRACTNUMBER_1.Text) &&
(DropdownCOSLead2.Selected.Value = Blank() || 'COS Lead' = DropdownCOSLead2.Selected.Value) &&
(DropdownProcessingStatus_1.Selected.Value = Blank() || 'Processing Status'.Value = DropdownProcessingStatus_1.Selected.Value) &&
(DropdownDIVISION_1.Selected.Value = Blank() || Division = DropdownDIVISION_1.Selected.Value) &&
(DropdownCOSSpecialist_1.Selected.Value = Blank() || 'COS Specialist' = DropdownCOSSpecialist_1.Selected.Value) &&
(IsEmpty(ComboBox2.SelectedItems) || 'COS Specialist1' in ComboBox2.SelectedItems.Value)
),
"Modified",
SortOrder.Descending
)

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.
SamanthaLavoie 161 on at

Like
a
(0)

Report
Copy link

Link copied!

It's giving me a delegation warning and not populating my gallery with data. How can I overcome this?
SamanthaLavoie 161 on at

Like
a
(1)

Report
Copy link

Link copied!

Notice the blue lines under the "&&" and "││" in the screenshot of my formula bar above.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
HI @SamanthaLavoie ,

Just adding some extra suggestions here - @Rajkumar_404 's response is correct for the question you posted.

The below addresses (possibly only partially) the Delegation issue as the top filter still needs to return record numbers under your limit for this to work fully. Also, Len() covers both IsBlank and IsEmpty.

With( { _Data: SortByColumns( Filter( 'WORK LOG', StartsWith( 'Contractor Name', SearchBoxCONTRACTORNAME_1.Text ) && StartsWith( 'Contract Number', SearchBoxCONTRACTNUMBER_1.Text ) && ( Len(DropdownCOSLead2.Selected.Value) = 0 || 'COS Lead' = DropdownCOSLead2.Selected.Value ) && ( Len(DropdownProcessingStatus_1.Selected.Value) = 0 || 'Processing Status'.Value = DropdownProcessingStatus_1.Selected.Value ) && ( Len(DropdownDIVISION_1.Selected.Value) = 0 || Division = DropdownDIVISION_1.Selected.Value ) && ( Len(DropdownCOSSpecialist_1.Selected.Value) = 0 || 'COS Specialist' = DropdownCOSSpecialist_1.Selected.Value ) ), "Modified", SortOrder.Descending ) }, Filter( _Data, Len(ComboBox2.Selected.Value) = 0 || 'COS Specialist1' in ComboBox2.SelectedItems.Value ) )
SamanthaLavoie 161 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, just to experiment, I added a new gallery to the screen, copied and pasted the gallery data fields from the gallery that was not working into the new gallery, and surprise surprise it works without errors. 😕 So, I'm not sure what was causing that but I deleted the old gallery and am using the one that works. Thank you both so much for your assistance, I really appreciate it.