Answered

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No
BurtekWu 12 on at

Like (0)

Report
Copy link

Link copied!

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,634 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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) )

1 people found this reply helpful.

Was this reply helpful? Yes No
rencygonzalez 20 on at

Like (1)

Report
Copy link

Link copied!
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,634 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You're welcome @rencygonzalez - glad that worked!

Was this reply helpful? Yes No