Share
ReportHi Folks,
I have a flow which accepts an excel file as input and creates list items in SPO based on it's contents. There's date column present in excel and it can contain both Serial format or ISO 8601 format. If I use formatDateTime function or directly add the serial value to SPO it will throw an error.
I understand we can convert serial number to date by adding it to 1899-12-30. But I'm using bulk update to SPO and have got rid of any apply to each actions to improve performance. I'm using select action to fetch all inputs from the excel rows. So if I use add days to handle serial format and the input is in ISO 8601 format, it will again throw error. I require an expression which can handle both ISO 8601 format and serial format.
Is this possible?
Thank you.
All responses (
Answers (
238
