Selecting items for a month in a sharepoint list

(0) Share

Report

Posted on by Universal_Power

I have a sharepoint list and I would like to pull the data from it and display it in a gallery for the month, this is the formula that I used:

Filter([@Leave], StartDate= Today(), -1, Months, "dd/mm/yyyy")

This does not work, Is there an alternative? if I use

Filter([@Leave], StartDate=Today(), "dd/mm/yyyy")

I can get it to display for entries made today but I need it to show all entries for the current month, advice? (Leave is the name of the list, startdate is the name of the column which is entered as dd/mm/yyyy in sharepoint)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BhaskarDhone 1,398 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
try this
Filter( [@Leave], Year(StartDate) = Year(Today()) && Month(StartDate) = Month(Today()) )

Was this reply helpful? Yes No
Universal_Power 67 on at

Like (0)

Report
Copy link

Link copied!

Awesome that worked perfectly! Thanks!

Was this reply helpful? Yes No