if(equals(item()?['DOB'], null), '', formatDateTime(item()?['DOB'],'yyyy-MM-dd'))
if(equals(item('Apply_to_each')?['DOB'], ''), null, addDays('1899-12-30', int(item()?['DOB']), 'mm/dd/yyyy'))
In excel and SharePoint list, the name of the field DOB and it is created with default parameters.
In excel date format is mentioned below:
Steps by Step will be highly appreciated.
Thanks in advance.
Hi @tusharmehta ,
You could check if the excel date column is a blank value. Add empty value in SharePoint field if excel date column is empty.
Thanks for the information,
I have a minimum of 4 dates in single records and I believe all those will be difficult to check with individual conditions.
What I have understood from your reply that when we are passing blank value to SharePoint list it is throwing the error correct ?
Does anyone have any input on this? I have a similar situation where I'm trying to import an Excel table into a new SharePoint list, but the workflow fails when it hits empty date fields in the table. I tried building a condition into the apply to each node, as pictured above, but I can't seem to get the expression right, the workflow fails to properly identify the blank fields and crashes before completing.
I have considered placing a false 1901 date in all of the fields that do not have one, but that seems like a clumsy workaround - can anybody provide an approach that will allow any blank field in the excel sheet to properly import as a blank/null field in the SharePoint list? Many, many thanks in advance!!!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.