Invalid Operation: Division by zero

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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 (1)

All responses (18)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you provide a specific formula?

Best Regards,
Wearsky

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

Like
a
(0)

Report
Copy link

Link copied!
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 Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!
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