web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to Filter Data By ...
Power Automate
Suggested Answer

How to Filter Data By Year

(0) ShareShare
ReportReport
Posted on by 115
Hi,
 
I was wondering if you could filter by year. I have done by month before, but when I try "StartOfYear" it does not work... does anybody know the best course of action to filter by the start of the year until now?
 
My code I attached may be wrong because I based it off of the month filter, I made.
 
Thanks in advance.
 
Edit:
Someone stated that I had a space in the title of the column. I fixed it and it still had an issue. The AI helper stated this:
 
The error you're encountering is due to referencing the 'startOfYear' function, which is not defined or valid in the context of the 'Get_items_Report_Approved' action. To fix this, consider using a different function or ensuring that the correct function is being called for the date manipulation you intend to perform.
FormatDate.png
FIlter Query.png
Categories:
I have the same question (0)
  • Suggested answer
    David_MA Profile Picture
    14,263 Super User 2026 Season 1 on at
    Your approach is correct, but I think there is a typo in your expression Query filters require that you use the internal name of the fields in the filter. In your screen shot, I see a space in the filter query for the Request Date. Internal names would never contain a space. You can get the internal name of a field by going into the list settings and opening the field. At the end of the URL will be the internal name. Use that in the filter.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 604

#2
Valantis Profile Picture

Valantis 502

#3
Vish WR Profile Picture

Vish WR 417

Last 30 days Overall leaderboard