cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niklasjegg
Super User
Super User

Sharepojt filter Query by custom date

Hello, i want to implement a specific filter query for my SPO get items action to only get me the items created between start and end of the year.
My filter query looks like this.

The employee email and trigger approval part is working fine. But i cant seem to get the date range from it.

Employee/EMail eq 'testemail@gmail.com' and TriggerApproval eq 'No' and ((Created gt '2021-01-01T00:00:00Z') and (Created lt '2021-12-31T00:00:00Z'))

 Any help would be appreciated. thanks a lot and merry christmas!

1 ACCEPTED SOLUTION

Accepted Solutions
ekarim2020
Super User
Super User

What results are you getting from the date range? Try modifying the date range to exclude the time stamp.

 

Created gt '2021-01-01' and Created lt '2021-12-31' 

 

I think the range you want is:

Created ge '2021-01-01' and Created le '2021-12-31' 

 

Ellis

View solution in original post

1 REPLY 1
ekarim2020
Super User
Super User

What results are you getting from the date range? Try modifying the date range to exclude the time stamp.

 

Created gt '2021-01-01' and Created lt '2021-12-31' 

 

I think the range you want is:

Created ge '2021-01-01' and Created le '2021-12-31' 

 

Ellis

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,533)