Error with addDays expression

Like (0) Share

Report

Posted on 28 Mar 2024 01:36:59 by SOOMALJ

Hi,

I am building a flow that sends a reminder email two weeks and one week in advance of a date entered in my share point list. I want it to send the email only if a choice column in the list is "No". I am receiving the following error with the addDays expressions to calculate the two/one week dates from the date entered in my share point list.

"Unable to process template language expressions in action 'Compose_-_two weeks reminder' inputs at line '0' and column '0': 'The template language function 'add Days' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'"

These are the expressions I am using for each compose action:

addDays(triggerBody()?['YourDateColumn'], -14)

addDays(triggerBody()?['YourDateColumn'], -7)

Any help/support to diagnose is truly appreciated!

Categories:

Business Process Flows

All responses (2)

Answers (0)

SOOMALJ 13 on 28 Mar 2024 at 12:55:18

Like (0)

Report

Re: Error with addDays expression

Hi @v-bofeng-msft

Thanks for your reply. I do have a value in the date column in the share point list. The format is as shown below. The error message also says 'The template language function 'add Days' expects its first parameter to be a string that contains the time.' Could it have something to do with the way the date and time is formatted in my share point list?
v-bofeng-msft on 28 Mar 2024 at 02:03:41

Like (0)

Report

Re: Error with addDays expression

Hi @SOOMALJ ,

Based on the error message, the error occurred because the value of triggerBody()?['YourDateColumn'] is null. Please check the output of triggerBody.

Best Regards,

Bof