cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
92859673
Level: Power Up

Flow Failed - InvalidTemplate

Hi

 

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
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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 

 

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

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 

 

View solution in original post

92859673
Level: Power Up

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

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (8,403)