Fill Blank rows with 0 using IF and ISEMPTY

I'm trying to better understand the IF and ISEMPTY function on one of my flows. Currently I have a column with rows of numbers while some rows are blank. I'm trying to create a formula that within that column if there are any rows blank, then fill with 0. The current formula I have written out is:

IF ISEMPTY([Column ]) THEN 0 ELSE [Column ] ENDIF

However, the output doesn't seem to fill the blank rows and am unsure what the error may be on my end to fix the formula.

Workflow

Output

Help

Accepted answers

DataNath

Hey @Tummi, IsEmpty() ought to work absolutely fine here. I'd check the rows are truly empty/null i.e. aren't just a space or something. If so you could try a slightly modified expression like:

IF ISEMPTY(Trim([Column ])) THEN 0 ELSE [Column ] ENDIF

This will strip whitespace and make the cell empty so that your if condition is triggered if that is the case.

All comments

cjaneczko

Are the cell empty or null? You may need to use IsNull([Column]) instead of IsEmpty().

DataNath

Hey @Tummi, IsEmpty() ought to work absolutely fine here. I'd check the rows are truly empty/null i.e. aren't just a space or something. If so you could try a slightly modified expression like:

IF ISEMPTY(Trim([Column ])) THEN 0 ELSE [Column ] ENDIF

This will strip whitespace and make the cell empty so that your if condition is triggered if that is the case.

Tummi

It's showing up as a blank value. Doesn't indicate as null

Tummi

Not sure how the trim fixed it but it definitely worked! Thank you for the help!

DataNath

@Tummi although the records *look* blank/empty, they sometimes aren't i.e. might just be a single space/bit of whitespace. Trim removes all whitespace and thus renders the record to be *actually* empty/null. Therefore, when you wrap the IsEmpty() check around that, it will trigger as true and fill with your 0 value. Hope this helps!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703