I am running the following flow to create items in SharePoint list from Excel files and I am receiving an error on the If expression I am using for the Date Returned column. I added the expression because I received an error for having no dates in some items.
The other date columns are pulling in as expected, but they all contain a date so no If expression was needed. I do have the DateTime format set to ISO 8601.
Is there something else I need to add to the IF statement?
if(equals(item()?['Date Returned'],''),null,item()?['Date Returned'])
Error Message:
That worked! Thank you!
Hey @CRMCS
Use the following expression it might help:
if(empty(item()?['Date Returned']),null,addDays('1899-12-30',int(item()?['Date Returned']),'yyyy-MM-dd'))
Link for Handling Excel Dates in Power Automate:
https://www.shanebart.com/ms-flow-excel-dates/
I hope this helps 🙂