Answered

Filter gallery based on multiple choice columns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I need to filter the data table "LCP." This table has multiple columns with the data type "Choices," allowing for multiple selections.

I have a ComboBox that takes the selection options "Web," "Mobile," "Workflow" from the column "Application." For example, if I choose the options "Web" and "Mobile" in the ComboBox, only the data should be displayed where both "Web" and "Mobile" are selected (intersection), not the data where either "Web" or "Mobile" is selected. The same applies when all three options are selected. Only the ones that offer all three options should be displayed in the gallery.

This is the filter I currently have, but unfortunately, it's not working:

Filter(LCP, cbApplication.Selected.Value in Application.Value);

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

If your Choice field in SharePoint is not set to "Allow multiple selections" and your Combo Box has been set to allow multiple selections:

Filter( LCP, CountRows(cbApplication.SelectedItems) = 0 || Application in cbApplication.SelectedItems )

If Choice field in SharePoint has been set to "Allow multiple selections" and your Combo Box has been set to allow multiple selections (not delegable):

If( CountRows(cbApplication.SelectedItems) = 0, LCP, Ungroup( ForAll( cbApplication.SelectedItems As _selections, Filter( LCP, _selections.Value in Application.Value ) ), "Value" ) )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik

Thanks for your response, but unfortunately, it doesn't work. It still gives me the data if at least one option of the ComboBox matches, and not all of them.
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous - recheck the post, I edited it as soon as I posted it
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik - we're not quite there. The same result comes out as before.
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous - the above solution is not delegable. Is your SharePoint list above 2000 rows?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik - yes, I have only 30 rows
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Apologies I misread you're initial question.

If you want to Filter the Gallery where the multi-select SharePoint field contains all selected items from your Combo Box control, you could try the below (again, not delegable).

Filter( LCP, !(false in ForAll( cbApplication.SelectedItems, ThisRecord.Value in Application.Value )) )

However, note that this expression will also return any items not selected in your multi-select SharePoint field, but are included in the selected items from your Combo Box control:

More info:
https://www.youtube.com/watch?v=Wr42PeW6_wU

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much!