cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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?

01.jpg

15 REPLIES 15
Impactful Individual
Impactful Individual

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

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.

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

01.png

Helpful resources

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

secondImage

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)