Unexpected Integers where dates should be with Excel Online (Business) connector in SharePoint Online
Importing an integer in place of a date in SharePoint Online and how to fix BLUF: if(empty(items('Apply_to_each_5')?['DOB']), null, if( isInt (items('Apply_to_each_5')?['DOB']), addDays ('1899-12-30', int(substring(items('Apply_to_each_5')?['DOB'], 0, 5))), formatDateTime (items('Apply_to_each_5')?['DOB'], ' yyyy -MM-dd'))) If you've ever tried to import data from an excel file into SharePoint Online, M365, formerly O365, aka down for leap days, you may have run across weirdness when importing a date. Your source excel document may know that that column is a date, or it may thing it's a string. Regardless, when importing, it imports a number like 30008, 20701, etc. This will also cause your flow to fail if you're importing into a date column. I'll take you through all the steps (but if you just need the formula, it's above) 1. Add an Excel Online (Business) connector to list th