Flows - DIV function returns 0 when using Compose

(1) Share

Report

Posted on by Julien5

Hi,

I'm going round in circles trying to figure out what I'm doing wrong.

I have a variable figure that I want to divide by a fixed number but I can't get the formula to work as intended. The input shows as zero as shown in the flow results

Compose availability = div(outputs('Compose_-_Total_Task_Duration'),outputs('Compose_-_Availability_target'))

The results of the flow

thanks for taking the time to help.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

trice602 15,402 Super User 2025 Season 2 on at

Like (2)

Report

Hi @Julien5 ,

You need to convert both values with float() to return the desired value, shown below.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (2)

Report
Hi @Julien5

You need to convert both numbers to float (decimal numbers) and the perform div operation.

Pls try the below expression:

div(float(outputs('Compose_-_Total_Task_Duration')),float(outputs('Compose_-_Availability_target')))

The above expression will return the results in decimal number.

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

Thanks

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

Like (1)

Report

Hi @trice602

Nice demonstration 👍

Thanks

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

Like (0)

Report

Hi @ManishSolanki ,

Great job on your post too! I like seeing us both in here at the same time. I also learn a lot from you on posts I don't know the answer immediately; I always read your solutions and learn! 💯💯💯💯💯

Was this reply helpful? Yes No
Julien5 17 on at

Like (1)

Report

Thank you both for your help, I couldn't figure why the formula worked with fixed integers but failed initially.
I made the changes and it worked nicely

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

Like (1)

Report

Hi @Julien5 ,

Nice to see these replies on Friday!

Was this reply helpful? Yes No
Rydman 96 on at

Like (1)

Report

Hi,

Thanks for this. This little conundrum reminded me why it's so frustrating to code in Power Automate. Is there a comprehensive, yet concise, documentation where you could find this stuff? I've been coding for 40 years, yet I get stumped again and again by this kind of non-intuitive quirks. Thank God for the helpful community!

Was this reply helpful? Yes No