Invalid Operation: Division by zero

[Anonymous]

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?

[v-xiaochen-msft · Accepted solution]

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

[Anonymous]

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%"
)

[v-xiaochen-msft]

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

[Anonymous]

Yes, it produces error even in a new environment.

[Anonymous]

@v-xiaochen-msft 

[v-xiaochen-msft]

Hi @Anonymous ,

The issue has been reported to the Microsoft team.

Best Regards,
Wearsky

[james_hathaway]

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:

• Warning of when a new Authoring Version is going to be available
• Clear Advertised Release Notes for the changes in the new version
• the OPTION to upgrade your app to the new version, or continue using the version you are on.
  • To give us the ability to run proper Testing on a separate App instance before upgrading the App in production
• the Ability to ROLL BACK to the previous authoring version
• the Ability to give FEEDBACK about the issues that an new version has created
• "Developer" Support that allows us to bypass the USELESS Microsoft Help-desk staff and actually talk to a member of the PowerApps Development Team that are actually involved in the new release (you know... like everyone else in the industry does on GitHub, which Microsoft OWN for Pete's sake!)

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.

[james_hathaway]

@v-xiaochen-msft
Please report to Microsoft and let us know what is being done about the bug.

Thanks.

[tinbantan]

Thank you. Your solution help me 😊