Answered

If statement to ignore 0 or null values and leave them as 0.

(0) Share

Report

Posted on by Watkins

Hi All,

I am working on building a flow which gets our data from a CSV file and reorganises it in the required format to upload to our other software, creating the new CSV file looks like this.

Below is the multiplication function I have used and I believe that if the value is 0 then it won't 'mul' it, see the screenshot of error.

mul(split(item(), ';')?[5], 1000)

I have tried a few different variations of if statements to try ignore the value if it is 0 and leave it as 0 but can't seem to get anything to work. Is there a way to do this or is there an error with the way I'm trying to do this? Thanks for the help in advance.

Regards,
Watkins

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi Watkins,

Pls try the below expression to handle null or empty values:

if(empty(split(item(), ';')?[5]),0,mul(split(item(), ';')?[5], 1000))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,441 Super User 2025 Season 2 on at

Like (2)

Report
@ManishSolanki wrote:

Pls try the below expression to handle null or empty values:

if(empty(split(item(), ';')?[5]),0,mul(split(item(), ';')?[5], 1000))

Since split() returns an array of Strings, you have to convert this to a to number type before multiplication.

Was this reply helpful? Yes No
Watkins 70 on at

Like (1)

Report

Hi Manish,

As Chriddle said it does need to be converted to a number type first before doing the calculation otherwise it won't calculate and will just return the same value, fairly new to PowerAutomate so I'm not aware how to do this yet.

Thanks,
Watkins

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Yes @Watkins

My friend @Chriddle is always right 😀

I have learnt a lot from him 🙏

Today's lesson is never share expression without testing it. Thanks @Chriddle 🙌

Was this reply helpful? Yes No
Watkins 70 on at

Like (0)

Report

Hi Manish,

Thanks for the help just getting the expression has already helped a lot and is a step towards completing this, would you know of a way to convert this to a number type?

Regards,
Watkins

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Watkins

Here is the expression:

if(empty(split(item(), ';')?[5]),0,mul(int(split(item(), ';')?[5]), 1000))

if input contains decimal number, use the below expression:

if(empty(split(item(), ';')?[5]),0,mul(float(split(item(), ';')?[5]), 1000))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
adedapo 256 on at

Like (0)

Report

mul(coalesce(split(item(), ';')?[5],0), 1000)

Was this reply helpful? Yes No