Answered

using a year drop down to filter a date

(0) Share

Report

Posted on by Markswan20

121

Is it possible to have a drop down box with the year 2021, 2022, 2023 etc where when the user selects the relevant year and the gallery will filter between a set date i'e 01/01/2023 - 31-12-2023 automatically?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Markswan20

Try this,

Filter( YourDataSource, Year(YourDateField) = Year(DropdownYear.Selected.Value) )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Markswan20

Try this formula, this is delegation free:

With(
{
tt: Filter(
AddColumns(
YourDataSource,,
"yrs",
Year(YourDateField)
),
yrs = Year(Dropdown1.Selected.Value)
)
},
tt
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Markswan20,

Have you solved your problem?

I just add something to @Rajkumar_404

Remember to set your year dropdown with following formula:

["2021", "2022", "2023" ]

Then set your Gallery items with @Rajkumar_404 's formula.

Check it and see if it works.

Was this reply helpful? Yes No
Markswan20 121 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the delay, the code none delegable works perfectly thank you, i need to SORT the data with the newest 1st "fieldname" ('Log Date') where do i need to put this within the code to achieve this?

Was this reply helpful? Yes No
Markswan20 121 on at

Like (0)

Report
Copy link

Link copied!
I've sorted it using the following for other users

With( { tt: Sort(Filter( AddColumns( LogDataALL, "yrs", Year('Log Date') ), yrs = Year(Dropdown4.Selected.Value),NewCreatedBy=varUN ),'Log Date',SortOrder.Descending) }, tt )

Was this reply helpful? Yes No
Markswan20 121 on at

Like (0)

Report
Copy link

Link copied!

However i've just stumbled on another problem, when using this code i can't navigate to the selected records as it's not recognising the gallery, i use the delegable version and it's fine, any ideas

Was this reply helpful? Yes No