Answered

Filter a Gallery with a Combo Box with Sharepoint MultiSelect Value

(0) Share

Report

Posted on by Electrariley

Hi! I have already asked a few similar questions, but I am new so I have endless questions. I will also mention I am using power apps in teams.

I have a gallery and I would like to filter it with a multiselection combo box. So far I have the below filters/sort/search on my gallery.

SortByColumns(Search(Filter('business.plan','Add to App'=!"F"), TextInputCanvas1.Value,"Title"), "DueDate",SortOrder.Ascending)

My current combo box is hard coded as: ["Population 1","Population 2", "Population 3", "Population 4"] with the multi select turned on in properties.

My gallery is using a sharepoint list (called 'business plan') and the column I need to search with the combo box is called 'Population'. The population column in sharepoint is a multi value select value.

In my gallery, I currently have that column displayed through a concat so all the values are listed that are selected, but I would like to filter the gallery by specific populations. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
@Electrariley ,

What is different here to this solved post other than the adding of the SortByColumns? Assuming Population is a multi-value field and your Combo Box is also multi-selection - the last solution I provided based on the information you posted (adding the SortByColumns in now and a small alteration)

With( { _Data: SortByColumns( Search( Filter( 'business.plan', 'Add to App'=!"F" ), TextInputCanvas1.Value, "Title" ), "DueDate", SortOrder.Ascending ) }, If( Len(dropdowncanvas2.Selected.Value) = 0, _Data, Ungroup( ForAll( dropdowncanvas2.SelectedItems As _Sel, Filter( _Data, _Sel.Value in Population.Value ) ), "Value" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Electrariley 28 on at

Like (0)

Report

Hi @WarrenBelz. I thought maybe I messed something up when I added the sort because now when I select a value in my combo box the gallery doesn't filter, but your recommended code is not indicating an error either. Apologies, I have been sick so I'm probably also slow to grasp what is happening.

Was this reply helpful? Yes No
Electrariley 28 on at

Like (0)

Report

@WarrenBelz I re-entered the above and actually I am getting errors for the components in the gallery. For example, the gallery has title, subtitle, and body format. In the Text property I have ThisItem.'Training Plan Name' & " | "& Concat(ThisItem.Population,Value,", "). Do I need to update this to work with the filter? This is the component of the gallery I am trying to filter for Population.

The error says "The name isn't valid", but if I revert back to the original formula without the combo box everything works.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

@Electrariley ,

Two things - I have made a small change to the combo box empty filter, and tested here to get results, but all the fields in your list should be available in the gallery to reference.

The second issue is what is business.plan ? It is unusual to have . inside a data source name. YOu also mention a component - can you firstly try this in a gallery with everything simply on the screen.

Was this reply helpful? Yes No
Electrariley 28 on at

Like (0)

Report

Apologies @WarrenBelz I had to work and couldn't respond back as quickly. I did exactly what you advised. I deleted the gallery and remade it and now your code above works perfectly. The business.plan is actually 'business plan'. I realized that in the gallery it did not like thisitem.course number and wanted thisitem.coursenumber instead for the text property. The extra space was causing all the errors in the text properties in the gallery. Thank you for recommending to go back to a simple screen. It made it very clear where my error was. Super appreciate your patience.

Was this reply helpful? Yes No