Answered

Flow Failed - InvalidTemplate

(0) Share

Report

Posted on by 92859673

I'm getting a failed flow message and when I test it get the message below. Below that is the formula I'm using to email custodians 14 days prior to equipment on a SharePoint calibration register needs inspected. I'm using the exact same formula for another for another SharePoint list (a facilities register) and it's working perfect, any ideas?

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2812': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'.

equals(formatDateTime(item()?['Calibration_x0020_Due_x0020_Date'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), 14), 'MM/dd/yyyy'))

cheers

Darren

All responses (2)

Answers (1)

92859673 2 on at

Like (0)

Report

Re: Flow Failed - InvalidTemplate

Yeah I checked the calibration register and one piece of equipment doesn't have a calibration due date, so this must be causing flow to fail

I'm new at this, so thanks very much

cheers

Darren
Verified answer

vikulkar on at

Like (0)

Report

Re: Flow Failed - InvalidTemplate

Hello @92859673

Your expression looks fine but the error is probably because the value of

item()?['Calibration_x0020_Due_x0020_Date'] is being returned as null.

Please check the value in the column to ensure that it is not null