Answered

filter gallery to display only items with the current month

(0) Share

Report

Posted on by Sheila-01

Hello guys, some help needed here. How do I make my gallery display only items whose date have the current month. My sharepoint list has a date column named "Date". And how do i display my date as a medium date in powerapps. (e.g 7 April 2021 instead of 07/04/2021. )

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@Sheila-01
Filter(yourSPList, Month(yourDateColumn)=Month(Now()))

Was this reply helpful? Yes No
Sheila-01 13 on at

Like (0)

Report
Copy link

Link copied!

How about if i want the latest date to appear first?

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Sheila-01
SortByColumns(Filter(yourSPList, Month(yourDateColumn)=Month(Now())), yourDateColumn, Descending)

Was this reply helpful? Yes No
Stenly 70 on at

Like (0)

Report
Copy link

Link copied!

Hello @CNT ,

I did create app called TimeTracker for myself. I am adding one record per day and in some time there will be lots of records.
In my Gallery3 in Items I have this formula:
And it works like a charm. I see what I need to see, ascending is correct. Even search filed work as I need.
But how I can add into this formula information, that I want to see in my app only records for current month?
If I would want older records, I would just check records on my SharePoint list.

Thank you very much for your help!
Best regards, Stanislav

Was this reply helpful? Yes No