Unanswered

filter Gallery with 3 ddl and range date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

the client wants to filter gallery with a range date (for example: form 01.01.2020 to 01.03.2021) and three ddl (ddlcode,ddlSup,ddlStatus)

i am trying many formulas but none work in particular i don't know how to put them together and how to manage date range.

Tnx for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Rivius 269 on at

Like
a
(0)

Report
Copy link

Link copied!

You can Filter the gallery by doing a >= the lower date and <= the upper date, then i'm assuming the 3 ddl filters are selections of some sort or text entries the user can manipulate to affect the filter? You can add as many filter parameters as you want and do something like If not is blank <whatever the affecting filter controls are> filter using the IN argument.

Was this reply helpful? Yes No
Rivius 269 on at

Like
a
(0)

Report
Copy link

Link copied!
Here's an example of a filter I'm using with several fields:
Sort( Filter( [@colMOCFilteredRecords], If( !IsBlank(txtMOCFilterID.Text), txtMOCFilterID.Text in ItemNo, true ), If( !IsBlank(txtMOCFilterCreatedBy.Text), txtMOCFilterCreatedBy.Text in 'Header Submitted By', true ), If( !IsBlank(txtMOCFilterCreatedFor.Text), txtMOCFilterCreatedFor.Text in 'Header Requested On Behalf Of', true ), 'Header Division' in cmbMOCFilterDivision.SelectedItems.Value, If( !IsBlank(txtMOCFilterTitle.Text), txtMOCFilterTitle.Text in 'Header Title Of Change', true ), MOCStatus in cmbMOCFilterStatus.SelectedItems.Value, 'Header Change Classification' in cmbMOCFilterChangeClass.SelectedItems.Value ), 'Created On', varMOCSortAscDesc )

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

What is the formula you have tried and what are things like the Items properties of the dropdowns etc.?

In general, your formula will be along these lines:

Filter(yourDataSource, (IsBlank(ddlcode.Selected.Value) || yourcodeColumn = ddlcode.Selected.Value) && (IsBlank(ddlSup.Selected.Value) || yourSupColumn = ddlSup.Selected.Value) && (IsBlank(ddlStatus.Selected.Value) || yourStatusColumn = ddlStatus.Selected.Value) && yourDateColumn >= aDate && yourDateColumn <= aDate )

Of course the above is highly dependent on more information from you about the names of columns, column types, and Items properties.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randi,
each DDL belongs to a different share point list and must filter the gallery.

Was this reply helpful? Yes No