Unanswered

SharePoint list Get Items filter for current year

(2) Share

Report

Posted on by Earl20

105

I'm trying to figure out how I can filter the items my Get Items to only pull the items that are in the current year. Some of my items have a "future" date (2022)

The flow is a scheduled flow to run weekly. I first created a variable (named current year) to format the current date (utc) to only show the year 'yyyy'. Each of the SharePoint items has a date field ( named Due Date)formatted mm/dd/yyyy. I want the get items action to only pull the items that match my 'yyyy' variable. I tried Due Date eq 'current year' and also tried Due Date contains 'current year'. Both get an error message.

Thank you in advance for your help

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

eliotcole 4,363 Moderator on at

Like (0)

Report
Are you talking about a filter action? Or are you talking about the ODATA filters on the Get items action?

Often times there's a way to get exactly what you want here.

I haven't tried this, but am about to:

yearField ge '2021-01-01' and yearField lt '2021-01-01'
Using less than the first to avoid month/date nonsense.

Was this reply helpful? Yes No
Earl20 105 on at

Like (0)

Report

I'm referring to the ODDATA filter. I'm a newbie in power automate, r. I don't want to manually type the current year in a condition action then have Due Date equal it, because then every year I have to remember to go in a change the current year after 12/31

Was this reply helpful? Yes No
Verified answer

eliotcole 4,363 Moderator on at

Like (2)

Report
No, absolutely, I just wasn't aware that you needed the logic to get the years all set up, too. I was giving you the barebones to ensure that the actual query worked.

All you need to do is present the ODATA filter with the dates that you wish to be greater than or equal to in the first instance, and less than in the second. In the date format that your systems are setup for.

So either use an expression to generate the dates in the ODATA field, or have a variable/compose show them.

This works for the greater than or equals expression which you can either place in the field, or work it out as a string value in a Variable or a Compose:

concat(utcNow('yyyy'),'-01-01')

Here's the less than:

concat(add(int(utcNow('yyyy')), 1), '-01-01')

Here's how I've used it in my example flow where my date field (which also has time values in the actual list) is called "dateOfDeparture":

Was this reply helpful? Yes No