Invalid Operation: Division by zero

(0) Share

Report

Posted on by Community Power Pla...

Hello everyone,

Seems Power Apps made an update recently, my apps pop up many runtime error "Invalid Operation: Division by zero"

Imaging I have a formula written as

IfError(1/Cost, 0)

It should avoid this issue at all, but the error keeps pop up in the Apps Checker.

Is there a way we can disable this?

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

v-xiaochen-msft on at

Like (1)

Report

Hi @Anonymous ,

Please turn on this setting.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for reply however....
Turned on - Saved - Published - Closed - Reopen
The error message still there.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

If the problem persists, please try to change the version.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Hi @Anonymous ,

Does it work now?
If the problem persists, I will suggest you to try another formula.
If(Value(Cost)=0,0,1/Cost)

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, Wearsky
1. There is only one version in the authoring version dropdown
2. I tried to rewrote the formula as you suggested, but still no luck..

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Hi @Anonymous ,

So...Please try the formula .
If(IsBlank(Value(Cost)) ,0,1/Value(Cost))

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Nah...
Seems the formula error pops up that as long as there is dependent parameter in the denominator.
Regardless of whether and how you conduct error catching.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

Could you provide a specific formula?

Best Regards,
Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
RoundUp(ThisItem.Quantity / Value(ct_lb_ps.Text),0)
This formula is written in a Gallery Label.
`ct_lb_ps` is also a Gallery Label.
This Gallery is using a Collection as data source.
This Collection is ClearCollected from a database with dynamical filter from previous page.
---
So everytime if modified the formula, the error message will be gone until you Save and Reopen.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (3)

Report
Hi @Anonymous ,

Please try this formula.
If(IsBlank(Value(ct_lb_ps.Text)),0,RoundUp(ThisItem.Quantity / Value(ct_lb_ps.Text),0))

The formula works fine in my environment.

Best Regards,
Wearsky

Was this reply helpful? Yes No