CODEWITHSUNDEEP
filtersharepointpower-automate
Paul Garbenis
Paul Garbenis

Reputation: 1

How do I write a Power Automate Get-Items OData query to filter a SharePoint List on a date column

I have a Power Automate flow that I am trying to filter a SharePoint List on the Get-Items action using an ODate query. It is a date column. Name is '37_Day_Review_Due_Date'. The internal name of the column is '_x0033_7_Day_Review_Due_Date'. I am trying to compare it to the current date. I've tried the following:

_x0033_7_Day_Review_Due_Date eq 'formatDateTime(utcNow(),'yyyy-MM-dd')'

37_Day_Review_Due_Date eq 'formatDateTime(utcNow(),'yyyy-MM-dd')'

body('Get_items')?['_x0033_7_Day_Review_Due_Date'] eq '@{formatDateTime(utcNow('yyyy-MM-dd'))}'

Nothing works. Any help would greatly appreciated.

Upvotes: 0

Views: 14

Answers (0)

Related Questions