I have an Excel table with multiple columns that I would like to import to Planner as tasks. The flow I created works as expected when each cell of every column in the Excel table are populated with values. However, my flow is producing an error whenever I have null values in any of the columns as it’s expecting a string value. Can someone please provide me with expressions which would skip to the next cell of the column every time it finds a null value (empty cell)? I’m also having issues with importing dates in mm/dd/yyyy formats. This is my first time working on this kind of project, and it has been very frustrating, as I haven’t been able to find good resources on how to write custom expressions. I’d greatly appreciate any help!

I found this video on YouTube which was a little helpful. It uses custom expression to take care of null values in date columns. However, I don’t really understand what the expression is doing…especially why the person is using ‘1899-12-30’ in the expression. Please skip to 5:35 time stamp to see what I’m talking about. Thank you!