You’re offline. This is a read only version of the page.
Announcements
45
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?
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.
Share
Report
All responses (
Answers (
