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
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?
Solved! Go to Solution.
Hi @hsy ,
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.
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 @hsy ,
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:
Please check if it reports an error or works normally.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.