Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple & Multipage Filter

Hi we are building a CDS sourced app & want to have multiple (4) filters (dropdowns) on the first screen that once set hold across all screens. The fields we wish to filter by are across multiple entities. 


Each screen we want to hold the filter over has a form to display data that is ordered and searched via a gallery.


e.g. SCREEN 1 - The first filter we want is called 'Property', it is a common field to all entities. SCREEN 2 - on our assets screen (assets entitiy) we want to filter the gallery by the selection in the first screen. 


We have attempted many options and scoured the forums for help but are finally posting. Our current best (but failing) option is using the drop down to set a value "MyProperty" to the selection, then applying this to the gallery, but it doesn't carry. 


Part two will be to display an non controllable visual indicating which filters are applied.

Level: Powered On

Re: Multiple & Multipage Filter

It sounds like what you are currently doing is correct - using the Set function to store your variables from the DropDown lists that will persist across screens and use those to filter your galleries. Note that you must use the Set function as UpdateContext will not persist across screens.


Something like:


DropDownProperties.OnChange = Set(MyProperty,DropDownProperties.Selected.Value)

Screen2Gallery.Items = Filter(YourData,Property = MyProperty)


If you are using the Set command already then it might be the case your Screen2Gallery.Items formula could be incorrect given the complexity of having 4 seperate filters and returning the wrong set of results. If you could share what formulas you are using on the dropdown.OnChange event and your Screen2Gallery.items we could have a look to see if there are any issues.


As for part 2 of your question, if following the above method and setting a global variable you could do something like the below but extended for your multiple filters:


ActiveFiltersLabel.Text = "Filters: " & If(IsBlank(MyProperty), "Properties equal anything", "Properties equal " & MyProperty)



Not applicable

Re: Multiple & Multipage Filter

Thanks but it is proving very tricky to get working. 


Drop down (combo is called M_Filter_Property and is set to) 

M_Filter_Property.onchange = Set(MyProperty, Properties_ADAMM.Selected.Value)

The drop down now errors with "The types of the specified context varaiables are incompatible with the types specified elsewhere". No indication where/what it is incompatible with. 


FYI - Properties_ADAMM is our entitiy with each property & it's details.


On the assets (screen 2) gallery I tried. 

Gallery_Asset_View.Items = filter(Assets_ADAMM, PropertyAcronym = MyProperty)

 It didn't work, I'm assuming due to the error on the drop down. 


For reference we have built a stacked filter to allow searching by many fields, the filter function will stack into the follwing; 

Sort(If(IsBlank(TextInput_Asset_View.Text), Assets_ADAMM, Filter(Assets_ADAMM,TextInput_Asset_View.Text in AssetName,TextInput_Asset_View.Text in LocationofAsset, TextInput_Asset_View.Text in Manufacturer, TextInput_Asset_View.Text in Model, TextInput_Asset_View.Text in RatingorCapacity, TextInput_Asset_View.Text in SerialNumber)), AssetName, If(SortDescending2, SortOrder.Descending, SortOrder.Ascending)) 


Not applicable

Re: Multiple & Multipage Filter

Oh and the M_Filter_Property combo box is set to display & search ["PropertyAcronym"]

Helpful resources

New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,518)