how to filter date in gallery

(0) Share

Report

Posted on by venky232

i have date picker card and saved in excel through patch.

now i want to filter gallery based on Year & month

i have created dropdown for Year & month.

based on selection of month or year it should filter.

how to do this any idea?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @venky232,

What column in excel file you save date picker selected date?

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

General

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @venky232,

So you must use Text() function convert date into text string when you use Patch(), right? You should remember the date format, like "dd/mm/yyyy", we will refer to it later.

I think there maybe something date format issue when we extract year from the date, so I would suggest use a foo-like trick, the following formula will always returns the 4 digits of the year.

Right(ThisItem.Date,4)

For the month filter, I have a dropdown popululate with Sequence(12), and we could also extract the month from the date column like below:

Right(Left(ThisItem.StartDateGeneral,5),2)

You just need to use the Filter() as below:

Filter(Table1,Dropdown1.Selected.Value=Right(Date,4),Right(Left(Date,5),2)=Dropdown2.Selected.Value)

Note that I set the year dropdown with a Value column including all the year string.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

instead of selecting month & year from dropdown ,
it is possible to use date picker DataCard to select only month & year (without dates)?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @venky232,

You could only save the month&Year from the selected date in DatePicker by using

Text(DatePicker1.SelectedDate,"mm/yyyy")

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

my question is
i want to show only month & year in date picker (without dates) . so user can filter gallery by selecting month &year from date picker instead of dropdown.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI @venky232,

I thought I have replied this, I used the "could only" word, which means that you could only something format to keep the year and month from DatePciker, but you could not make the DatePicker display only year and month.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

filter not working
Filter(
Table2,
Category in varcat || IsBlank(varcat) || varcat = "All",
Datecolumn=Text(
DatePicker5.SelectedDate,
"mm/yyyy"
)
)

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @venky232,

Actually, I am confused what you want to achieve exactly.

The formula you provided is totally different the formula I provided, I think I have clarified it clearly how I configure the Year dropdown and month dropdow, please check it one more time.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

Sorry for confusion, i want to make user selection simply. that's why I'm trying to find alternate solution.
if we use combobox instead of Dropdown & date filter with below code will work?
Filter(Table1,ComboBox1.SelectedItems=Right(Date,4, Left(Date,5),2)) ?

Was this reply helpful? Yes No