How do I configure my Flow to handle the situation when the Date in XLS is blank?

Like (0) Share

Report

Posted on 21 Nov 2023 09:45:04 by 925stuart

Hi,

My Flow reads an XLS and writes to a List. When copying a Date field, I come across this problem. When the Date in XLS is valid, it copies fine. When the Date in XLS is blank, the Flow breaks. How do I configure my Flow to handle the situation when the Date in XLS is blank?

Thank you!

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

fchopo 7,972 Moderator on 21 Nov 2023 at 10:21:57

Like (0)

Report
Re: How do I configure my Flow to handle the situation when the Date in XLS is blank?

Hi @925stuart

You could use an expression like the following:

if(equals(item()?['StartDate'], null), '', formatDateTime(item()?['StartDate'],'yyyy-MM-dd'))

Where start date is the date column.

You could also use Coalesce function: Blank, Coalesce, IsBlank, and IsEmpty functions - Power Platform | Microsoft Learn

Hope it helps!

Ferran

Was this reply helpful? Yes No