The value 'Text' cannot be converted to a number.

(0) Share

Report

Posted on by Copycat

Good day beautiful people,

I have 3 fields:

Power Automate output field

MyFlowResponse.count - 1

And two calculation fields:

Round(TextCanvas12_3.Text * 0.0083 * 1.1, 2) & " EUR"

and

Round((40 + (TextCanvas12_3.Text * 0.00025) + (1 / 60) * (4 * 1.1)) / 60, 1) & " hours"

For both calculation fields I'm getting error that it cannot convert 'Text' to a number, but once I run the application, the errors disappear. They also appear in App Checker, but if I navigate to a screen where the labels are, the error from AC disappear as well.

I'm not sure where the errors comes from, all 3 labels are data type number. The text for 2 appears only because I added " hours" and "EUR", without that it is numeric.

How can I get rid of this error? I've tried to add Value() or Text() to the calculation labels but it changed nothing.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Copycat - A Label control outputs Text, irrespective of whether the field in the data source is type Number.

Have you tried wrapping the output of the Label with a Value function? e.g.

Round(Value(TextCanvas12_3.Text) * 0.0083 * 1.1, 2) & " EUR"

Was this reply helpful? Yes No
Copycat 71 on at

Like (0)

Report
Copy link

Link copied!
Good day @Amik
thank you for your replay but unfortunately yes, I've tried to do it. My initial formula included Value() but it does not change anything.

I've tried also to change this formula:
If( IsBlank(Concat(att_CL_Excel_3.Attachments, Name)), 0, MyFlowResponse.count - 1 )
Because the flow is triggered by OnAddFile property of the attachment field on the very same screen so I thought that if there is no attachment, the value in this field goes crazy and needs to be set up as "0".

This again did not help. I also don't understand why the error disappears once the attachment is added.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Copycat - please could you copy the example formula I provided and insert it into your app, and then a share a screenshot of the error message?

Was this reply helpful? Yes No
Copycat 71 on at

Like (0)

Report
Copy link

Link copied!
@Amik of course.
The label which holds this formula is called TextCanvas3_1 and the formula is
Round(Value(TextCanvas12_3.Text) * 0.0083 * 1.1, 2) & " EUR"

And the error message:

My main issue is, that the notification pops out when you use the app, which will definitely confuse the users.

Was this reply helpful? Yes No
Verified answer

Mihaela08zl 99 on at

Like (2)

Report
Copy link

Link copied!

Hello @Copycat , try in the properties of the text input to format is as number it will work

If this solved your problem, please choose my answer.

Best regards
Mihaela

Was this reply helpful? Yes No
Copycat 71 on at

Like (0)

Report
Copy link

Link copied!

Good day @Mihaela08zl,

I'm using "modern" labels for text, not text input but this looked promising and I wanted to change it from text to text input:
Is there a way to get numeric as you did in modern controls or I have to use the "old" one instead?

Was this reply helpful? Yes No
Mihaela08zl 99 on at

Like (1)

Report
Copy link

Link copied!

@Copycat Round(TextInputCanvas1.Value * 0.0083 * 1.1, 2) & " EUR"

Was this reply helpful? Yes No
Copycat 71 on at

Like (1)

Report
Copy link

Link copied!

@Mihaela08zl worked!
Thank you very much for your help!

Was this reply helpful? Yes No