{"id":2878,"date":"2023-05-16T19:31:43","date_gmt":"2023-05-17T02:31:43","guid":{"rendered":"https:\/\/doubleecpu.com\/?page_id=2878"},"modified":"2023-07-08T22:47:11","modified_gmt":"2023-07-09T05:47:11","slug":"multi-filter-selection","status":"publish","type":"page","link":"https:\/\/doubleecpu.com\/index.php\/multi-filter-selection\/","title":{"rendered":"Multi-Filter Selection"},"content":{"rendered":"\n

Add Filter icon<\/h2>\n\n\n\n

Add Filter Icon then Set Boolean Variable true using OnSelect =Set(Show_Filter_Container, true). This will make the Container with Filter Values appear on the screen.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Add Container and align to Filter Icon
adjust container colors to match branding of PowerApp<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Set Container Property Visible to Boolean variable (Show_Filter_Container)
Copy and paste Filter icon inside of container and adjust colors to match branding of PowerApp (*Existing icon can be copied and pasted to use previously set colors). <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Change AccesibleLabel and Tooltip = “Close Filter Pop Up” and OnSelect = Set(Boolean_Variable, false) to hide container
This will enable filter to pop to become visible or be hidden<\/p>\n\n\n\n

Add Gallery to display Filter_Type<\/h2>\n\n\n\n

Create a collection for selecting Filter_Type and Add “Show_Filter_Type” column default value to true
; ClearCollect(Collection_Filter_Type, AddColumns(Distinct(List_Rocket_Data, Title), “Show_Filter_Type”, true))<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Insert a blank vertical gallery then add a checkbox
Set checkbox size to match layout: font, size, colors
Set Template Size to fit data and Padding = 0
Add Label on gallery using checkbox
lineup checkbox and gallery, resize to fit container
Set checkbox to false default, Text Filter_Type
Set OnCheck:
Clear(Collection_Filter_Type)
Collect(Collection_Filter_Type, Distinct(Filter_Type),
AddColumns(“Show_Filter_Type”, true)
Clear(Collection_SubFilter_Type)
Collect(Collection_SubFilter_Type, Collection_App_SubFilter)
AddColumns(Show_SubFilter, true)
To Clear Selection erase data then recreate
Set OnUnCheck:
Clear(Collection_Filter_Type)
Collect(Collection_Filter_Type, Distinct(Filter_Type),
AddColumns(“Show_Filter_Type”, true)
Clear(Collection_SubFilter_Type)
Collect(Collection_SubFilter_Type, Collection_App_SubFilter)
AddColumns(Show_SubFilter, true)

Add Checkbox for SubFilter, default false, Text = SubFilter
Set OnCheck:
Clear(Collection_SubFilter)
Collect(Collection_SubFilter, Collection_App_SubFilter) AddColumn(“Show_SubFilter”, true)
Set OnUncheck:
Clear(Collection_SubFilter)
Collect(Collection_SubFilter, Collection_App_SubFilter) AddColumn(“Show_SubFilter”, false)<\/p>\n\n\n\n

Add Gallery to display SubFilter_Type<\/h2>\n\n\n\n

Add Gallery for SubFilter. Set Items to Collection_SubFilter_Type sorted by Filter_Type, Filter_Number
Add checkbox set default to Show_SubFilter, Text = SubFilter, Tooltip = “Select Sub Filter To Show”
Set OnCheck:
Patch(Collection_SubFilter, ThisItem, {Show_SubFilter: true})
Set OnUnCheck:
Patch(Collection_SubFilter, ThisItem, {Show_SubFilter: false})<\/p>\n\n\n\n

Add Date Selection to establish date filter<\/h2>\n\n\n\n

Add Date Picker, set default date = DataAdd(Today(), 365, TimeUnit.Days), Start Year = 2000, End = 2050
Add Button Rename Filter, Text=Filter
Set OnSelect:
Clear(Collection_Filtered_Details)
ForAll(Filter(Collection_SubFilter, Show_SubFilter)
Collect(Collection_Filtered_Details
, ClearCollect(Filtered_Sorted, Filtered)
Filter(Collection_App_Details, Filter_Type = Collection_App_Details[@Filter_Type], DatePicker1.SelectedDate < Collection_App_Details[@Start_Date]
} ) )<\/p>\n","protected":false},"excerpt":{"rendered":"

Add Filter icon Add Filter Icon then Set Boolean Variable true using OnSelect =Set(Show_Filter_Container, true). This will make the Container with Filter Values appear on the screen. Add Container and align to Filter Iconadjust container colors to match branding of PowerApp Set Container Property Visible to Boolean variable (Show_Filter_Container)Copy and paste Filter icon inside of … <\/p>\n

Read more “Multi-Filter Selection”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2878","page","type-page","status-publish","hentry"],"featured_media_urls":[],"_links":{"self":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/comments?post=2878"}],"version-history":[{"count":5,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2878\/revisions"}],"predecessor-version":[{"id":2904,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2878\/revisions\/2904"}],"wp:attachment":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/media?parent=2878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}