Hello,
I have an Excel Online table that I want to add Dates to a Sharepoint List, but I can only pass 2 items, not all of them.
How can I solve that?
You would use an if statement to check for null values in the date item. Because I'm still learning I don't know how to do that with expressions but this article might be a place to start... Handling Excel Dates in Microsoft Power Automate (shanebart.com). There might be other helpers on the forum with previous tips for constructing if statements.
I found the following post that may help you:
There are also some folks posting on other sites about how to do this. I found some useful information while searching 'flow convert excel date to datetime'.
It looks like the common solution is to add an expression to the create item action
I used the following expression but you can make this more robust to missing/empty values with some if conditions in the expression.
addDays('1899-12-30', int(item()['Date']), 'MM-dd-yyyy')
Is the date in the Excel workbook stored in Excel's serial date format? If so, you may need to convert it before adding days. Perhaps.