Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

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

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?


Impactful Individual
Impactful Individual



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."

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 (
        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.

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

Impactful Individual
Impactful Individual

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

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.

Impactful Individual
Impactful Individual

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


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

excel table in sharepoint.

Impactful Individual
Impactful Individual

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

Annotation 2019-11-29 113257.png

Is number


Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,083)