web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Date filter

Power Apps

Answered

Date filter

(0) Share

Report

Report

Posted on by NurNina

375

Hi, I have a question. I have a gallery that will show only promotions within the month. How do we filter for such situation. Im having trouble with the filter formula.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

DanishIslam 108 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi NurNina,

Lets say you want to filter the gallery for the items created in current month only, try this formula-

Filter('Data Source', Month(Created) = Month(Today()) && Year(Created) = Year(Today()))

Hope this helps.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NurNina ,

Which data source do you used to store the promotions records? A SP List or a Excel table?

Do you add a Date type column in your data source to store the Start time of the promotions records?

I assume that you add a Date type column in your data source (may be a SP List) to store the Start time of the promotions records, is it true?

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery to following:

Filter( DataSource, Month(StartTime) = Month(Today()) && Year(StartTime) = Year(Today()) )

Note: The StartTime column represents the date type column in your data source, which used to store the start time of the promotions records.

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No

Join the conversation