Answered

Date Format / IF Statement

(0) Share

Report

Posted on by IndigoFaux

Heya, I am trying to work out an IF statement that also changes the date format, and returns an empty space if there is no date from the field.

if(equals(formatDateTime(outputs('Get_item')?['body/field_19'], 'dd-MM-yyyy',''),null,formatDateTime(outputs('Get_item')?['body/field_19'])))

I though that would work but it returns this error:

The template language function 'if' expects three parameter: the condition to test as the first parameter, the value to return if the condition is true as the second parameter, and the value to return if the condition is false as the third parameter. The function was invoked with '1' parameter(s).

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @IndigoFaux,

You have something syntax wrong with your expression.

The if statement expects three parameters, the first parameter should be a complete formula that identify if the current date string is null.

if(<condition>, <ifConditionIsTrue>, <ifConditionIsFalse>)
if(empty(<dynamicContentWithDate>), <ifConditionIsTrue>, <ifConditionIsFalse>)

Here is a complete if statement that if the current data string is empty, assign it with a null value, otherwise, format it as 'dd-MM-yyyy':

Here I suppose that you have a date field in the SP list:

if(empty(triggerOutputs()?['body/Date']), null, formatDateTime(triggerOutputs()?['body/Date'],'yyyy-MM-dd'))

Or on your side, please modify as below:

if(empty(formatDateTime(outputs('Get_item')?['body/field_19'], 'dd-MM-yyyy')),null,formatDateTime(outputs('Get_item')?['body/field_19'],'dd-MM-yyyy'))

Was this reply helpful? Yes No
IndigoFaux 52 on at

Like (0)

Report
Copy link

Link copied!

I still get this error with that formula:

'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Was this reply helpful? Yes No
Verified answer

IndigoFaux 52 on at

Like (0)

Report
Copy link

Link copied!

if(empty(Outputs('Get_item')?['body/field_19']), null, formatDateTime(Outputs('Get_item')?['body/field_19'],'dd-MM-yyyy'))

The above formula worked for anyone that might run into the same problem.

Was this reply helpful? Yes No