Expression error

(0) Share

Report

Posted on by Community Power Pla...

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)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Anonymous

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

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

Like (0)

Report

@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,270 Most Valuable Professional on at

Like (0)

Report

@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... on at

Like (0)

Report

@ScottShearer

It isn't letting me attach the screen shots

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
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... on at

Like (0)

Report

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

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

Like (0)

Report

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