Unanswered

The value 'Text' cannot be converted to a number

(1) Share

Report

Posted on by rencygonzalez

In my powerapp I have a label that does a simple calculation. The label displays the difference between two labels. I use Value() around labels so I am not sure what I am missing. This only shows after I publish the app, I commented out the code , published again and the error is gone. I hope someone can help me.

If(IsBlank(BudgetOverview.Text || InvoiceTotal.Text),"",Value(BudgetOverview.Text-InvoiceTotal.Text))
 
I get the following error : The value "Text" cannot be converted into a number.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

KennyJ 168 on at

Like (2)

Report

Try wrapping the individual controls in the Value function. I.e Value(BudgetOverview.Text)- Value(InvoiceTotal.Text)

Was this reply helpful? Yes No
rencygonzalez 20 on at

Like (0)

Report

I did try that as well and still didn't work.

Was this reply helpful? Yes No
BurtekWu 12 on at

Like (0)

Report

Try this approach:

If(IsBlank(BudgetOverview.Text) || IsBlank(InvoiceTotal.Text),"",Value(BudgetOverview.Text)-Value(InvoiceTotal.Text)).

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
It almost sounds as though the BudgetOverview or InvoiceTotal labels contain the literal value "Text"

It might be worth doing an additional check in the If statement to ensure that both of these are numeric. That might remove the error.

If( IsBlank(BudgetOverview.Text) || IsBlank(InvoiceTotal.Text) || !IsNumeric(BudgetOverview.Text) || !IsNumeric(InvoiceTotal.Text), "", Value(BudgetOverview.Text) - Value(InvoiceTotal.Text) )

Was this reply helpful? Yes No
rencygonzalez 20 on at

Like (1)

Report
This worked thank you!! @timl

If( IsBlank(BudgetOverview.Text) || IsBlank(InvoiceTotal.Text) || !IsNumeric(BudgetOverview.Text) || !IsNumeric(InvoiceTotal.Text), "", Value(BudgetOverview.Text) - Value(InvoiceTotal.Text) )

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

You're welcome @rencygonzalez - glad that worked!

Was this reply helpful? Yes No