{"id":7199,"date":"2024-10-22T13:15:55","date_gmt":"2024-10-22T13:15:55","guid":{"rendered":"https:\/\/softreetechnology.com\/blog\/?p=7199"},"modified":"2024-10-23T07:37:31","modified_gmt":"2024-10-23T07:37:31","slug":"filter-powerapps-gallery-dropdown-multiple-dropdowns","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/","title":{"rendered":"Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns"},"content":{"rendered":"\n
While working on a Power Apps project, I got a challenge where I needed to filter the gallery based on a single and multiple dropdowns.<\/p>\n\n\n\n
In this PowerApps case study I’ll demonstrate how to filter the PowerApps gallery using multiple dropdown controls and a dropdown menu.<\/p>\n\n\n\n
I have a SharePoint List named \u201cWorkTask\u201d This list contains the fields below.<\/li><\/ul>\n\n\n\n
Column Name<\/td>
Data Type<\/td><\/tr>
Task<\/td>
This is a Title column with a single line of text. I just renamed it to \u201cTask\u201d<\/td><\/tr>
Description<\/strong><\/td>
Multiple lines of text<\/td><\/tr>
Status<\/td>
Choice<\/td><\/tr>
Start Date<\/td>
Date and time<\/td><\/tr>
End Date<\/td>
Date and time<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/figure>\n\n\n\n
In Power Apps, there is a Gallery control and a Dropdown control. The dropdown control has values like All, In Progress, Not Started, and Completed.<\/li>
When a user selects any value from the dropdown, the gallery will display each record from the SharePoint list based on the selected dropdown choice field.<\/li><\/ul>\n\n\n\n
To achieve the above example, follow the steps below. Such as:<\/p>\n\n\n\n
Open Power Apps -> Create Power Apps canvas app -> Connect the SharePoint list [WorkTask] to the app. Once you connect, it will look like the screenshot below.<\/li><\/ul>\n\n\n\n
<\/figure>\n\n\n\n
Select a Power Apps Screen [WorkTask] -> Set its OnVisible property to the code below.<\/li><\/ul>\n\n\n\n
If() = This function helps us to evaluate multiple unrelated conditions<\/li>
drpStatus.Selected.Value = \u201cAll\u201d PowerApps dropdown name and \u201cAll\u201d is the collection item value<\/li><\/ul>\n\n\n\n
<\/figure>\n\n\n\n
Save, Publish, and Preview the app. When the user selects a specific value from the dropdown control, the gallery will display the filtered records, i.e., [Completed], as in the screenshot below.<\/li><\/ul>\n\n\n\n
<\/figure>\n\n\n\n
This is how to filter a PowerApps gallery by dropdown choice field.<\/li><\/ul>\n\n\n\n
Power Apps Filter Gallery By Dropdown Date<\/strong><\/p>\n\n\n\n
Next, we will discuss how to filter a PowerApps gallery by dropdown date.<\/p>\n\n\n\n
Example: I have a SharePoint list named \u201cTraining Courses\u201c. This list contains the below fields.<\/p>\n\n\n\n
Column Name<\/strong><\/td>
Data Type<\/strong><\/td><\/tr>
Course Name<\/td>
This is a Title column with a single line of text. I just renamed it to \u201cCourse Name\u201d<\/td><\/tr>
Description<\/td>
Multiple lines of text<\/td><\/tr>
Course Start Date<\/td>
Date and time<\/td><\/tr>
Course End Date<\/td>
Date and time<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/figure>\n\n\n\n
In Power Apps, there is a Horizontal gallery control; this gallery displays each record from the SharePoint list based on the date selected in the dropdown menu.<\/li>
To work around the above example, follow the below steps.<\/li>
On the PowerApps -> Connect the SharePoint list, i.e., [Training Courses] to the app. Once you connect, it will look like the screenshot below.<\/li><\/ul>\n\n\n\n
<\/figure>\n\n\n\n
Insert a Dropdown control and set its Items property as:<\/li><\/ul>\n\n\n\n
Items = Distinct(<\/p>\n\n\n\n
‘Training Courses’,<\/p>\n\n\n\n
‘Course Start Date’<\/p>\n\n\n\n
)<\/p>\n\n\n\n
Where, \u2018Training Courses\u2019 = SharePoint Online List \u2018Course Start Date\u2019 = SharePoint Date Field<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Then, insert a Gallery control and set its Items property as:<\/li><\/ul>\n\n\n\n
DrpStartDate- Power Apps Dropdown Name<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Save, Publish, and Preview the app. Select any particular date from the dropdown control, and the gallery will filter and display the records based on that date.<\/li><\/ul>\n\n\n\n
This is how to filter a PowerApps gallery by dropdown date.<\/p>\n\n\n\n
Power Apps Filter Gallery By Dropdown and Search<\/strong><\/p>\n\n\n\n
Let\u2019s see how to filter a PowerApps gallery by dropdown control based on the search.<\/p>\n\n\n\n
Example<\/strong>: I will take the same SharePoint list [Training Courses] for this example.<\/li>
In Power Apps, there is Gallery control, Text input, and Dropdown control. This gallery displays each record from the SharePoint list based on the dropdown control and search results.<\/li>
I faced a delegation warning [Yellow triangle]. The warning message appears as \u201cDelegation warning. This formula\u2019s \u201cSearch\u201d part might not work correctly on large data sets.<\/li>
I created a Power Apps collection [colCourses] using my SharePoint list to overcome this Power Apps delegation warning. Then, I filtered a Power Apps gallery by dropdown without delegation warning, <\/li><\/ul>\n\n\n\n
On the Power Apps canvas app -> Select App object and set its OnStart property as: <\/p>\n\n\n\n
Insert a Text input, make its Default property blank [\u201c\u201d], and set its Hint text property as \u201cSearch Course Name\u201d like below.<\/li><\/ul>\n\n\n\n
<\/figure>\n\n\n\n
Then, insert a Dropdown control and set its Items property as:<\/li><\/ul>\n\n\n\n
Search()= This function allows users to search for and filter items in a PowerApps gallery.<\/p>\n\n\n\n
SrpStartDate= PowerApps Dropdown<\/p>\n\n\n\n
TextInput1= PowerApps Text input<\/p>\n\n\n\n
‘Course Name\u2019= SharePoint Text column<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Save, Publish, and preview the app. This gallery will display the filtered records based on the search results and selected dropdown value as in the screenshot below.<\/li><\/ul>\n\n\n\n
<\/figure>\n\n\n\n
This is all about how to filter a Power Apps gallery by dropdown and search.<\/p>\n\n\n\n
How to Filter a PowerApps Gallery With Multiple Dropdowns<\/strong><\/p>\n\n\n\n
Now, we will see how to filter a PowerApps Gallery With Multiple Dropdowns step by step.<\/p>\n\n\n\n
Set up a SharePoint List<\/strong><\/p>\n\n\n\n
First, we will create a SharePoint List named IT Help Desk with the various columns:<\/p>\n\n\n\n
Column Name<\/td>
Data Type<\/td><\/tr>
Request ID<\/td>
Number<\/td><\/tr>
Subject<\/td>
Title (Single line of text)<\/td><\/tr>
Request Date<\/td>
Date and time<\/td><\/tr>
Category<\/td>
Choice (Servers, User Workstation, Basic Software, Data Center)<\/td><\/tr>
Look at the SharePoint Online list below:<\/li><\/ul>\n\n\n\n<\/figure>\n\n\n\n
Create a Power Apps Blank Canvas app<\/p>\n\n\n\n
Next, we will create a new blank canvas app in Power Apps and add some input controls. Follow the instructions below:<\/p>\n\n\n\n
Sign in to Power Apps with valid Microsoft credentials.<\/li>
Go to Apps -> Expand + New app -> Select Canvas.<\/li>
Provide the App name and choose the Table Format -> Click on Create.<\/li>
Connect the SharePoint List Datasource connector (IT Help Desk) to the app.<\/li><\/ul>\n\n\n\n<\/figure>\n\n\n\n
Next, insert three Dropdown controls and rename them to ddCategory, ddPriority, and ddReqUser.<\/li>
Now, I want to retrieve all the dropdown values from the specific SharePoint list columns, namely Category, Priority, and Request User.<\/li>
I also want to give each dropdown control a blank value. Every value from the SharePoint list, including a blank value, will be available in the dropdown.<\/li>
To do so, we will create a collection with a blank value on the screen\u2019s OnVisible property as: <\/li><\/ul>\n\n\n\n
OnVisible = ClearCollect(<\/p>\n\n\n\n
CategoryWithBlank,<\/p>\n\n\n\n
{Category: Char(160)}<\/p>\n\n\n\n
);<\/p>\n\n\n\n
Collect(<\/p>\n\n\n\n
CategoryWithBlank,<\/p>\n\n\n\n
Distinct(<\/p>\n\n\n\n
‘IT Help Desk’,<\/p>\n\n\n\n
Catagory.Value<\/p>\n\n\n\n
)<\/p>\n\n\n\n
);<\/p>\n\n\n\n
ClearCollect(<\/p>\n\n\n\n
PriorityWithBlank,<\/p>\n\n\n\n
{Priority: Char(160)}<\/p>\n\n\n\n
);<\/p>\n\n\n\n
Collect(<\/p>\n\n\n\n
PriorityWithBlank,<\/p>\n\n\n\n
Distinct(<\/p>\n\n\n\n
‘IT Help Desk’,<\/p>\n\n\n\n
Priority.Value<\/p>\n\n\n\n
)<\/p>\n\n\n\n
);<\/p>\n\n\n\n
ClearCollect(<\/p>\n\n\n\n
ReqUserWithBlank,<\/p>\n\n\n\n
{ReqUser: Char(160)}<\/p>\n\n\n\n
);<\/p>\n\n\n\n
Collect(<\/p>\n\n\n\n
ReqUserWithBlank,<\/p>\n\n\n\n
Distinct(<\/p>\n\n\n\n
‘IT Help Desk’,<\/p>\n\n\n\n
‘Request User’.DisplayName<\/p>\n\n\n\n
)<\/p>\n\n\n\n
);<\/p>\n\n\n\n
Where, CategoryWithBlank, PriorityWithBlank, ReqUserWithBlank = Provide the Collection Names, Category, Priority, ReqUser = Specify the Collection Headers, \u2018IT Help Desk\u2019 = SharePoint List Name, Category.Value, Priority.Value = SharePoint Choice Columns, \u2018Request User\u2019.DisplayName = SharePoint Person Column,<\/li><\/ul>\n\n\n\n<\/figure>\n\n\n\n
Then, set these collections to each and every Dropdown\u2019s Items property: Category: Items = CategoryWithBlank Priority: Items = PriorityWithBlank RequestUser: Items = ReqUserWithBlank<\/li><\/ul>\n\n\n\n<\/figure>\n\n\n\n
Save and Close the app. Open and Preview the app once again; you can see the outputs below:<\/li><\/ul>\n\n\n\n<\/figure>\n\n\n\n
Next, add a Vertical Gallery Control and set its Layout to Title, subtitle, and body. Apply all the code on each gallery label\u2019s Text property as:<\/li><\/ul>\n\n\n\n<\/figure>\n\n\n\n
Then, Select the Gallery Control and set its Items property to the code below:<\/li><\/ul>\n\n\n\n
Items = Filter(<\/p>\n\n\n\n
‘IT Help Desk’,<\/p>\n\n\n\n
ddCatagory.Selected.Value = Blank() Or Catagory.Value = ddCatagory.Selected.Value,<\/p>\n\n\n\n
ddPriority.Selected.Value = Blank() Or Priority.Value = ddPriority.Selected.Value,<\/p>\n\n\n\n
ddReqUser.Selected.Value = Blank() Or ‘Request User’.DisplayName = ddReqUser.Selected.Value<\/p>\n\n\n\n
)<\/p>\n\n\n\n
Where, ddCatagory, ddPriority, ddReqUser = Dropdown Control Names<\/li><\/ul>\n\n\n\n
Save the app and then run a preview. The gallery will filter and show all the SharePoint list records when all the dropdown controls have empty values.<\/li>
When you choose options from the various drop-down controls, the gallery filters and shows those specific values by your drop-down selections.<\/li><\/ul>\n\n\n\n
Before Applying Filter<\/p>\n\n\n\n<\/figure>\n\n\n\n
After Applying Filter<\/p>\n\n\n\n<\/figure>\n\n\n\n
This is how to filter a PowerApps Gallery With Multiple Dropdowns.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"
While working on a Power Apps project, I got a challenge where I needed to filter the gallery based on a single and multiple dropdowns. In this PowerApps case study I’ll demonstrate how to filter the PowerApps gallery using multiple dropdown controls and a dropdown menu. I have a SharePoint List named \u201cWorkTask\u201d This list contains the fields below. Column […]<\/p>\n","protected":false},"author":1,"featured_media":7200,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[306],"tags":[340,323,358,356,357,359],"class_list":["post-7199","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerapps","tag-canvas-apps","tag-powerapps","tag-powerapps-canvas-app-filtering","tag-powerapps-canvas-app-tutorial","tag-powerapps-gallery-filter-example","tag-sharepoint-list-filtering-in-powerapps"],"yoast_head":"\n
Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"While working on a Power Apps project, I got a challenge where I needed to filter the gallery based on a single and multiple dropdowns. In this PowerApps case study I’ll demonstrate how to filter the PowerApps gallery using multiple dropdown controls and a dropdown menu. I have a SharePoint List named \u201cWorkTask\u201d This list contains the fields below. Column […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-22T13:15:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-23T07:37:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Filtering-PowerApps-Gallery-By-Dropdown-Multiple-Dropdowns.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/","og_locale":"en_US","og_type":"article","og_title":"Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns - Softree Technology","og_description":"While working on a Power Apps project, I got a challenge where I needed to filter the gallery based on a single and multiple dropdowns. In this PowerApps case study I’ll demonstrate how to filter the PowerApps gallery using multiple dropdown controls and a dropdown menu. I have a SharePoint List named \u201cWorkTask\u201d This list contains the fields below. Column […]","og_url":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/","og_site_name":"Softree Technology","article_published_time":"2024-10-22T13:15:55+00:00","article_modified_time":"2024-10-23T07:37:31+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Filtering-PowerApps-Gallery-By-Dropdown-Multiple-Dropdowns.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns","datePublished":"2024-10-22T13:15:55+00:00","dateModified":"2024-10-23T07:37:31+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/"},"wordCount":1671,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Filtering-PowerApps-Gallery-By-Dropdown-Multiple-Dropdowns.png","keywords":["Canvas apps","PowerApps","PowerApps Canvas App Filtering","PowerApps Canvas App Tutorial","PowerApps Gallery Filter Example","SharePoint List Filtering in PowerApps"],"articleSection":["PowerApps"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/","url":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/","name":"Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Filtering-PowerApps-Gallery-By-Dropdown-Multiple-Dropdowns.png","datePublished":"2024-10-22T13:15:55+00:00","dateModified":"2024-10-23T07:37:31+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#primaryimage","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Filtering-PowerApps-Gallery-By-Dropdown-Multiple-Dropdowns.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Filtering-PowerApps-Gallery-By-Dropdown-Multiple-Dropdowns.png","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/filter-powerapps-gallery-dropdown-multiple-dropdowns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Filtering PowerApps Gallery By Dropdown & Multiple Dropdowns"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=7199"}],"version-history":[{"count":1,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7199\/revisions"}],"predecessor-version":[{"id":7201,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7199\/revisions\/7201"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media\/7200"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=7199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=7199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=7199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfTUaidrYHzzsu-YsemVl0fkJjC457EXDQcVJy2XPeT_2hW451jIr0NdeRo5G8ARYGzGXunPYVHglnsz4B5RR8q6F7eCqt8em14umcNppLOmFml7LT1V-bMJv0_pkV3rfwRg1EgquXgaaSwLewssuwbcrrSsfeJUTIcL0SToecItuChHTfIwQ?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfRClftZ6pcWQzVqc2QssZjPSmfxfTNBHirvgOmmbKBnFb-Cl20PqyAXfenuOBgTZ8m1_-9SdUTk65qmktttC8k06KXCBYHhKtOKAy_dvFynLvqqnwt0DJXTuXTDKL_r1aI0hMEg0Cs_vkbxirAxjqOMq0vCsYdW0MclpyX5JYaRWBhOaXgluo?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfo1_1F6V8yU5stSpdiemR8HaaaeAvO-MTpdsPZtF5MdciOWS4WinXCOyf7YbVm30dL_TDlxrMuEHpF-qvSliPk5P24rRLzAK8U7XcHjRaFUkexVcNgMg2EZIFL-d3Q0cNsYHq_jV-2OYVMRASTbK32UbCraIrbVmd-Us1gh4OxBFWwP6iKoV8?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcWWsbk--H1PkoF_KqK-JlupG17VTNJ3p3sTE5B0tnK6NwQwAJdhJeBUzE3xGqlcPqMum-0iCZmOLdmHzF-PoRTl_zH6l8IxZoJznhwlEG-tFJyyXuefpflN1zeTq4TSL7utHrB3fivcIoZzfFSrjk3yexJYe_7UR_FM5p_4XjIl6QPHC__7g?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcAGdxdwo0HllhP-xZaDNwtzVJDzzrpwD9b_nPZeJ7Cj6N40HlyVIbcaWiMYB3xGyVpz_ZIhkb8R0zDFgPXY8UjoWv-6SqfXGmaofSjTOP6SIWmza2HQuqzgLLKVuqlbvtrdT4RpQCazH9l945rYiEFjDcyjBRXT_swdSiarn2qzcm9V7tDbOo?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXd_byHVugSiuIxOZnC-nWSx88uCeB9pLJIBs0KMLDonVAnPw0oqiwIS_DyXLWH8De95pMfW95f8vr-ca74ksLo8slSZT-eWo6lreLTw2i5GDqsfm9geo5zjagiJLW8tc-LWPCZGq5T6CBCft903_ulVLXca8nptb1viFgmj9bN9Hw5puqX6As4?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdnxH1wBacEeQmD-xGOBE_f462zpOKqu_a6ep6GaXpaNu7zAtH4n8SvFVE2lCEM9MasiUjYv6oR8yj7oiDlFJmNRFUAaqGtvU7GFdDbMoMqAWWxUMQBatlSzieWi64xmGLZYbmM2sv9SWTKyYgckv6hNr0zjOgYyOS85wx1mZueWNc4aWp7KNg?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdBvUuB3czQj0dxtqjP6KpVqmKuU3l1PyTlRcJNXYBIPNuNMRArNEDSWrW8KTINhKJmPcmwZLP7CDJlbh6EApzwPi-CUP1-Gw6WpX72eQd7y5XkfRJjpCuo0YhDHbb2ld1UX2NerbX5rLmQ8_YFcE8ucVlr9Q36KVE9Eg8vaMppXXJ0Zw5kJ_g?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXePPwzxPyEgWvXbcstnwLabMMDTzzcndNUCoqZG2Fkd-6Jm2AIjxATba5d9ACL5VFqh67PgrVWvBbRyPlc1CZ20RGE2H5zCGU9UidBwcwKqTNz-vPcmamPc-VI9xJXaYIo2LgDwvjvlIz3GZ8t1CPnnJ4u97MT8nw52xNbvDT2I1gIxMquEMN8?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXc9X-YYKMX8KYDIb2EixGJWVER9CzK_EkQNcJsp5X4nJZnADbbEmNLL3CmYl0uJTem2YkgpHVgpVCmFru_vC_lkaDOhhmXpmlKNt88_KTnHIEP30xFe9Yq-2rLp-SWaYEdTNM3eWTsH95bh1PnrIOmw5SanPhHHbQyG0EmA5y_GGNcYj93tuXU?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfTwRYhqufb_lQcfO36KUnGsKlqk-lZExkCPBjFZL2DYnGOVwCbLMZdVuverpvIjZQSpEX_It1swlEE0fWRQq8vwUe3-dgM3oQRrW2P7gPCrm51ALjmHj4pB7DNSn3mxU_AlKlx3_2_OLOj2iIMXJPwwvdwwuAqJWNfSDtIKzt4xi6gIM75umw?key=MV-heud1iQMPBUAyUqBNAA\")
This is how to filter a PowerApps gallery by dropdown date.<\/p>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe3U-FAYXu5sRzlZ4_6Pk5boV_NN5jx5wMOoFbNp5ji2LJwGnFGr8Ob13BSSHzKnn4S_G6rfb-ZnMTU-VRmfBO7_34lKwVV1cieF2TNPZgEGpBjBm53F0BsBvXjScHMfK55snZt3HwOyaAQFiHywgD6ReXyROKvc4WB3Z4_foVDxBBRoe49tg?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcYI9DqPZ23_KMbn2l7Y0Os0hzknzmJouLkelZBoXxHVVsogIPgryqKQUxH9c1HFF9XX2bLHR36E9zb5BUjzELkthcrKuj5ooiac8Y7m4LueArsRiOXmUzBBhzcSDzfH5-LFkM1ruIsLTBMbcf8d6cwGpT8Dmph8k_SyPsZjo4tIFSvPhsLyw?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeyabOaqXNacmTplOISuoLT5k7eo26TulbjjbdpnQB4dObRYb_PCWm6CjJupG8ddBMACBMV8vs2FExDtDJj3j-8Q9kW84aZWxnKD-xTyGUdJA7kE7INLeeT16VfVT-BvVY7sRi1ecsBfPLy7s3fH7AEKSJNFnSbo_zhZHXNyEzj1D6Fc-E6I_Y?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcrL6BkHWNeWPa93e64hRUE3flWJ-UluAYQbqrCy9SZ3D-z10OHF2H3bAo9gvgfgZQSSRC2MGK3AqyP4LWOM4f0bwbtRiUqY8wIzZhRWp2l5KX04jFwjq0ZQkpX5CCtLWsC5U5gWa3y6Sin9HDqFC2Mfy9h_xKHaQGgRkpbJPXXVpIhn4Wa4LE?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdvEjtIf7SW47Gk0fr41h49qQ-04VgK5tvo2ZCUDOcHXNJjmkFZ51nKBEzplVXwAKBhdEbCUbOByjRzPXMbyS2pudn22POsuRiE_o9aoILT8RGUePxEBuAs7b3J2dgaZmk0kLuzj-QQesUJ_qz1xwssjMoUShmKnvqXxK0DbIswKZsG0GSmdC4?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe7852un6zKXknyrh6typczuXS4E85XLlM7uVOzLrJ1W8Tz4dDwcjKqUSgblZycwBAzsVi248wb-MFDHz-kZiM4EXD65hIZUdYBCid25irQv7EJaTVtaUkw5ruE1vjr4h3T2vBM0y8nlomA76A2t0SoLBh_qYc6BSpBofg3ZvQi05KLol9s7Pw?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXd2JYexIGuhSY5Yttwr3t-4yvDVSm8BnR3aTVuRXZ43bRR8vnt86AAbn8lBNN5UnV9INoZGgzyv8fD0smfOgIPN2qemKAIJyn9CnQQVbrUrmk53LoN5e7ngiqbWlw_u9_quoWHyg_NhQ5L-VIbsM6NxZtAhGWFMrBbHtWap8hS1p9Bj4sLrcw?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXe440oOX-B-wnjX6hN3-d2wmKZ5u4OFxQDUzkL0JlsztPgjj7FPz04JeBpHrLTW02PJLs3e7V0-rfDoC7ulWqLYUw2W_IFdhnFRI9_ddirCOJZk-VDE6HXEIbsBmpjuwqzmps015qzj12Ds8Af5mCMQRpK7H20lgdNKpm5EMw9O3QHEakYuLXc?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeYbfaxZXibBG4KFOVL1hE3cuEjyv3gPFQkFJPYrJnaOli_9Gxi6weACm6Oyy9HQ7luxNaJZficIZFH43kMtPRHiCPCfbOIxdZ6KO41ZwkbbrymD_20vK48RzBjsCyzD3YelB8FeST4vOJOM8zXMO8MtlECN3bf9Tl8ikGR06_mxuITV7GJO7E?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXciohFb5ogG3qPy-MFQZukGAJMSWNWasKIKuHHngk2T7sz8kkVUE5eMG8SnEtV6PdYrend9NG263MdiWJ6JQnXEZK7SIivDGl48tz-28EipRCqT9Lbi_oaymsxeIXa1HXzV8Z9cr1SSNWbJgJU0TDtlXfr9zHjHREMnNVWJjF9m15PjLo97Ppk?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcOV3UAetFT9f8MS5Tg8dq88d7yhUcVmzmlMYInoUmqsRewp8sRj034J0jCEthfGH0IOFPgAvrelU-L2U4zeDlAv_r3YbjR-9Yys1sVEyoWAErsfetOLEAJ0C_DluL_WxxqDuqI_VH39sFqF-p5wrcJyQgBI6Qjn6AgBTVQbWcU2q6O_fXgbhc?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdr6myXF57Qdjsc1OD27FKFDYcpr_HbyLgU9zHKO27hAXGgSEp5yMdl5y6W9vELQmNJbWXXpgpIRpeVsE6Scq1lq0XhYZzBEnQZwmyJjs4PnMyE8GaPWrL_8lzulooJxqCiYYxAOSW_ZWrVBt96ZsCYwJPZV9Y13ms8Ek-FgWM2-fJ1bdLt8zg?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeRhrwCg-l0y3fHP17kGrIjg-9ArzMqnjxryP6bdCdq0YeGKaI0nDcezJObkrZiAJUUI9YxOquDUlCwY3bcwYDmxRG8yjSzI1ijBZytPmHutOMSrTbXsIgiNqu1CVJ4SIsUpTf3X_qxLMbTHZpV7JAeIMeNvcgTzQcEy0Qh2ffC3_6Z_6ZgZXk?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n![\"\"\/](\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdgJxQ87xlXbNLBXQB-yHLuFG2QqaarVP6xHqg5v8cGGeFE7pGDABFf4b3RPoxGYXAdCl__TlI6JExWtBHjRhiTHcrmMkOLr2URf2k4hBMWciKgD-StaGCKtO1xzd9EYg-JrjvZg3mKtW8SKrHbG4smAV64k46MNyMmXjPQpWtaCQ6yRiwJ6ik?key=MV-heud1iQMPBUAyUqBNAA\")
<\/figure>\n\n\n\n