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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!