Unanswered

A text field with the setting "number" is not a number

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I created a text field, set the "number" in the settings, not the text. I enter the letters in the field and they disappear, I enter the numbers and they remain.
I try to enter data from a field into a table using Patch, but I get an error that "2234" is not a number!
I created a text field with the formula

If (IsNumeric (TextInput5_5); "Numeric!"; "Is not")

and the field also shows that this is not a number.

How can this be? Have I missed the setup somewhere?

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

Sort by

SeanHenderson 1,104 on at

Like (1)

Report
Copy link

Link copied!

Hi,
Try:
If(IsNumeric(Textinput5_5.Text), "Numeric!", "Is not")

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This works for a text field, but not for entering into the database. After checking it shows that this is a number, but nevertheless, when I enter it, I get an error due to the fact that 1, this is not an error.
I enter the bash using the function

Patch (
        Table1_1;
        Defaults (Table1_1);
        {
            Format: Dropdown1.Selected.Formats;
            Order: Value (TextInput5.Text);
            'Stream-eat': TextInput5_1.Text;
            Code: TextInput5_2.Text;
            Marked: Value (TextInput5_3.Text);
            Deleted: Value (TextInput5_4.Text);
            Gluing: Value (TextInput5_5.Text);
            Domotano: Value (TextInput5_6.Text);
            Surname: Surname;
            Start: DateTimeValue (DatePickerS.SelectedDate & "" & StartTimeH.Text & ":" & StartTimeM.Text);
            Stop: DateTimeValue (DatePickerF.SelectedDate & "" & FinH & ":" & FinM);
            Report: templatename
        }
    ) ;;

And in the remaining fields he likes everything, in the remaining numbers and without problems, but here are some mistakes.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Here is a picture. Ignore the empty fields, they are cleared after entering.

Was this reply helpful? Yes No
SeanHenderson 1,104 on at

Like (0)

Report
Copy link

Link copied!

For which field is it expecting a number and getting the error? What data type is that field in your data source?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Field textinput5_5. Gluing.
The number is in the field settings, the number is in the table properties, I will pass the number, but for some reason the table is not passed a number.

Was this reply helpful? Yes No
SeanHenderson 1,104 on at

Like (0)

Report
Copy link

Link copied!

What is the data source? CDS? SQL Server? SharePoint?

In the data source, what is the data type for the Gluing field set to?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

excel table in sharepoint.

Was this reply helpful? Yes No
SeanHenderson 1,104 on at

Like (0)

Report
Copy link

Link copied!

In your SharePoint list, what is the data type for the Gluing column?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Is number

Was this reply helpful? Yes No
SeanHenderson 1,104 on at

Like (0)

Report
Copy link

Link copied!

Your data source is just an excel file, SharePoint isn't involved?

Wherever you are trying to store the data it is telling you that the column you are trying to store it in will not accept a number.

Try Text(TextInput5_5.Text)

Was this reply helpful? Yes No