Unanswered

Invalid Expression

(0) Share

Report

Posted on by nomad187

I would like to set up a flow where users will receive an email when an expiration or due date is 30 days or less away. The dates are in a Sharepoint list. I found a build that stated it would accomplish my goal. However, I get the following error:

The expression "Due Date le 'addDays(utcNow(), variables('varNumDays'), 'yyyy-MM-dd')'" is not valid. Creating query failed.

I tried changing "Due Date" to "DueDate" and "le" to "eq". None of this works. The column on my SharePoint list is titled "Due Date".

Here is the flow:

If any more info is needed to help solve this, please let me know.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @nomad187

Both of your expressions are showing as strings, they should appear as dynamic blocks. Just cut the expression and paste it into the expression builder and try again.

Damien

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (3)

Report

@nomad187

I agree with @DamoBird365 but want to add that using Due Date won't work - you need to use the columns internal name and internal names have no spaces. It is most likely DueDate. To verify, go to list settings and click on the column name. The internal name will be at the end of the URL after field= .

Was this reply helpful? Yes No
nomad187 12 on at

Like (1)

Report

@DamoBird365 and @ScottShearer

The first expression did indeed cause the error. I did as you suggested and cut/paste it into the expression builder.

The second issue was the internal name was OrderNumber. Once I changed Due Date to that, it worked correctly.

Thanks for the help!

Was this reply helpful? Yes No