Expression error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I keep receiving this error when I try to run a flow:

The expression "5/13/2020" is not valid. Creating query failed.

I am using the expression

addDays(utcNow(),14,'M/d/yyyy')

to help send an email reminder at 14 days prior to the due date of a SharePoint list but can not get it to work with the expression. Can anyone assist me with this.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

For SharePoint you need to use the following date format: 'yyyy-MM-dd'

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer
It is still not working and bringing up a date that doesn't exist. It is now saying 2020/34/13

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Can you post a screen shot of your Flow as well as a screen shot of your last run - the more detail the better.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer

It isn't letting me attach the screen shots

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

When you configuring Filter Query, you should fill leas two parameters in Filter Query to filter items.

It seems that you are filling only one parameter in Filter Query.

First, you could run Get items action without configuring Filter Query and check the body of Get items action.

Get the actual name of date column and fill it in Filter Query.

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft
Here is the workflow that was created. I have that expression.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

As I mentioned in my previous reply, you are configuring a single parameter in Filter Query.

The output of Compose only is a date, you could add a date column to compare with this output and filter items.

Please check this link and get more details about Filter Query:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

Best Regards,

Was this reply helpful? Yes No