Unanswered

Filter Query for Date in Power Automate

(0) Share

Report

Posted on by Sibangi

Hello all!

I have a sharepoint list, with date column. I want to create a flow where it filters the data based on current month and year.

This is the way I am doing it now, but the result is not what I need.

It returns an excel with everything. For this particular sample I would only need 05/2023 but instead I got so much more. Any help would be so appreciated!

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (2)

Djuuu 65 on at

Like (0)

Report

Can you provide more context? How does the column in sharepoint look? Is it Date formatted?

Was this reply helpful? Yes No
Sibangi 33 on at

Like (0)

Report

Thank you for getting back, yes the date column is date formatted in the sharepoint list. Currently, people are manually filtering the dates referring to the current month and year. This needs to be automated. So if there are entries with the following dates
15/05/2023
16/05/2023
12/06/2023
14/05/2024

I would only need the rows with the highlighted dates. Does this help explain?

Was this reply helpful? Yes No
Djuuu 65 on at

Like (0)

Report

Yes, thank you. So based on your informations, your flow ist currently this:

Calibration_x0020_Months eq'Concat(utcNow('MM'))' which translates based on your information into this:

15/05/2023 eq '05'

Can you try to use this one here:

year(Calibration_x0020_Months) eq year(utcNow()) and month(Calibration_x0020_Months) eq month(utcNow())

Was this reply helpful? Yes No
Sibangi 33 on at

Like (0)

Report

I did try

but it throws an error saying 'not a valid query' The column name for date is 'Due_x0020_Date'

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

You probably want to check if:
The Sharpoint date is greater or equal utcNow('yyyy-MM-01')
and less than addToTime(utcNow('yyyy-MM-01'),1,'month')

Was this reply helpful? Yes No
Djuuu 65 on at

Like (0)

Report
Can you try to add an additional step "Filter Array" and add this under custom:

@And( equals(formatDateTime(item()?['modified'], 'yyyy'), formatDateTime(utcNow(), 'yyyy')), equals(formatDateTime(item()?['modified'], 'MM'), formatDateTime(utcNow(), 'MM')) )

modified needs to be changed to your column....

btw, i also thought about that it could be easier if you add addtional columns to your list if possible.

Was this reply helpful? Yes No
Sibangi 33 on at

Like (0)

Report

I tried the above. Ideally it should return
All of these dates, but instead it is returning only the first one.
I am attaching my flow snippet
Thank you for all the support, the list can be changed, but multiple departments are involved, hence the list remains untouched is the idea.

Was this reply helpful? Yes No
Djuuu 65 on at

Like (0)

Report

Can you try this one instead?

And sorry, i try to help as good as i can, but without the orginal table it is hard to try the solutions before posting 😄

Use
formatDateTime(item()?['Created'], 'MM/yyyy')

on the left side with your column, and on the right side with utcnow

Was this reply helpful? Yes No
Sibangi 33 on at

Like (0)

Report

Atleast you are trying to help me! Which is so great.

'on the left side with your column, and on the right side with utcnow' - I didnot understand, can you show me?

Was this reply helpful? Yes No
Verified answer

Djuuu 65 on at

Like (0)

Report

Filter Array:
1.:formatDateTime(item()?['Due_x0020_Date'], 'MM/yyyy')
is equal to
2.: formatDateTime(utcnow(), 'MM/yyyy')

Was this reply helpful? Yes No