cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78
Helper III
Helper III

Get Items - filter on a SharePoint list date column (multiple words)

Trying to create a filter in flow for a SP list where if the date of Archive 2 is in the past, the flow works

 

'Archive_x0020_2' lt 'addDays(utcNow(),+0,'yyyy-MM-dd')'

 

This is what I currently have and I'm getting a invalid query.  This syntax looks to be correct but I can't find any examples online where the column is multiple words so I went with how SP sees the column name

 

The query is not valid.
clientRequestId: e9bd9ff2-aa15-43a1-835d-f51cb30d26d3
serviceRequestId: e9bd9ff2-aa15-43a1-835d-f51cb30d26d3

4 REPLIES 4
Paulie78
Super User
Super User

Get rid of the single quotes around 'Archive_x0020_2' for starters.

Assuming your expression is an expression and not just written into the query?

@Paulie78 

 

Correct

 

Capture.PNG

 

Paulie78
Super User
Super User

Did removing the single quotes help?

@Paulie78 

 

Different error message.  So you can't filter on a calculated column?

 

The field 'Archive_x0020_2' of type 'Calculated' cannot be used in the query filter expression.
clientRequestId: d74ea6ca-9cb2-4f02-ad47-673d9a96f98d
serviceRequestId: d74ea6ca-9cb2-4f02-ad47-673d9a96f98d

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,470)