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?
Thank you. Your solution help me 😊
@v-xiaochen-msft
Please report to Microsoft and let us know what is being done about the bug.
Thanks.
It would appear that this error has resurfaced in Authoring Versions:
3.21123 & 3.21124
There are a number of bugs that were previously fixed, but have reappeared in these versions - so there's been some really shoddy Integration Testing by the product Team, and they've merged in a load of features that undoes the previous bug fixes.
As is also noted on this forum, Microsoft have also disabled the ability to use a previous Authoring version (the drop-down lost only ever gives you the option for the current version), so we're all kind of screwed until Microsoft (re)fix the engine - we simply can't edit any of our Apps at all, as doing so automatically upgrades them to the newest Authoring version, with no option to roll back.
We cannot continue using a product that just changes under our feet, without any warning, choice, or even the ability to feedback - As we all know, Microsoft support is WORSE THAN USELESS if you happen to know even a tiny bit about programming or development - so very difficult to actually talk to somebody that knows more than you do).
Microsoft NEED to manage their Authoring Release process a LOT better. we need:
In the mean time - PLEASE ALLOW US TO ROLL BACK TO AUTHORING VERSION 3.21115, which is the last version we used that didn't randomly throw "divide by zero" errors.
Hi @Anonymous ,
The issue has been reported to the Microsoft team.
Best Regards,
Wearsky
Yes, it produces error even in a new environment.
Hi @Anonymous ,
Please do a simple test to verify if your environment has problems using IfError() function.
1\ Open this setting
2\ Add a textinput control 'TextInput1' and set its Default property to:
""
3\ Add a lable and set its Text property to:
IfError(1/Value(TextInput1.Text),0,1/Value(TextInput1.Text))
Please check if it reports an error or works normally.
Best Regards,
Wearsky
Thanks you, thats great. it also works fine for me this time as well.
However can you report/forward this issue to developers?
Cause I have many formulas like this, some are very calculation intense, add extra layer of verification in a clunky app is like grinding it to halt. eg.,
Text(
(Sum(
Cart_Gallery_Cart.AllItems,
Cart_TextInput_Price * Cart_TextInput_Quantity
) - Sum(
Cart_Gallery_Cart.AllItems,
Cart_Label_TotalPrice
)) / Sum(
Cart_Gallery_Cart.AllItems,
Cart_TextInput_Price * Cart_TextInput_Quantity
) * 100,
"[$-en-US] #0.00%"
)
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
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.
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
58
Michael E. Gernaey
42
Super User 2025 Season 1