web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Error when filtering G...

Power Automate

Answered

Error when filtering Get ITEMs by date

(0) Share

Report

Report

Posted on by Bigshow

60

Hi

I have a sharepoint list which i wan to filter based on a date column. I onyl want items where the date is less than 7 days from todays date.

I have created a var which is todays date - 7 days

addDays(utcNow(),-7,'yyyy-MM-dd')

I then filter using this var with

DateofUKPost Le 'Var'

But whenever i run it i receive the error The expression "DateofUKPost Le '2021-01-26'" is not valid. Creating query failed.

any ideas as to what im doing wrong

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@Bigshow Please use below expression for var

formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd')

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Hello @Bigshow ,

the Le (less or equal) must be in lower-case: le.

DateofUKPost le 'Var'

Was this reply helpful? Yes No
Bigshow 60 on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No
Bigshow 60 on at

Like (0)

Report

Thank you, this worked

Was this reply helpful? Yes No

Join the conversation