
I have a column with date and time in excel and there are empty values. I need to export the table into the Sharepoint list. I used an expression:
if(empty(items('Apply_to_each')?['Date']), null, formatDateTime(item()?['Date'], 'yyyy-MM-dd HH:mm tt'))
but got an error. How can I solve this?