Flow intermittently failing with parsedate expression

(0) Share

Report

Posted on by KBRedStone

I have flow that saves PDFs to Sharepoint, an AI model that extracts data and then saves to Google Sheets.

I added a parsedate expression to each field and the files processed correctly all last week. Now today, I get the following error although, the files have been added to Google as expected.

InvalidTemplate. Unable to process template language expressions in action 'Insert_row' inputs at line '0' and column '0': 'The template language function 'parseDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#parsedatetime for usage details.'.

I removed the expression, flow succeeded but now I'm getting 2023-12-08T00:00:00Z again.

I'm using the wrong expression?

Screenshot 2024-03-11 at 5.23.17 PM.png

Screenshot 2024-03-11 at 5.32.40 PM.png

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report
Re: Flow intermittently failing with parsedate expression

Hi @KBRedStone

You need to handle empty values in the input date column. For checking empty or null values, apply if function using an expression. Here is the sample expression:

if(empty(<dynamic content>),'',formatDatetime(utcNow(),'MM/dd/yyyy'))

The above expression will not apply formatDatetime function if dynamic value of column is empty or null.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.