cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Formula Level Error Managment & Addition

Once I turned on formula level error management it is impossible to add the value for blank cell:

ie

textinput1.text=300

IsBlank(textinput2.text)=true

value(textinput1.text)+value(textinput2.text)=0

How to correct this and get the real sum of 300?

3 REPLIES 3
Highlighted
Super User
Super User

Re: Formula Level Error Managment & Addition

@Titiwai 

I attempted to recreate the unusual case you saw when formula level error management was turned on and value(textinput1.text)+value(textinput2.text)=0.  However, my experiment produced a result of value(textinput1.text)+value(textinput2.text)=300.  Is it possible that something else is causing the problem?

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Helper II
Helper II

Re: Formula Level Error Managment & Addition

I am not very sure. The textinput is within the form/datacard. Wonder what the format is for empty textinput in this setting?

Highlighted
Community Support
Community Support

Re: Formula Level Error Managment & Addition

@TitiwaiDo you mean if you turn off that feature, you will get the real sum of 300? Could you share your test steps and screenshots?

In my experience, if your form is in Edit mode and the Items property is empty, whatever you input in the data card, it always returns blank, so please check if your form mode and Items property. Further, you can add two text input boxes out of form to test and check if your formula work fine.

Snipaste_2019-12-24_11-20-49.png

Sik

 

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (14,125)