I am trying to populate a html table using the following expression. I case, if the cell content (date) is blank then i need nil in the table and in case it is not blank, i need it to return the date in a specific format.
if(empty(item()?['Checklist_sent_by_Auditor'], 'Pending', formatDateTime(adddays('1899-12-30',int(item()?['Checklist sent by Auditor'])), 'yyyy-MM-dd')))
The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: '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). Please see https://aka.ms/logicexpressions#if for usage details.'.