cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Error on parsing

Hi there,

 

How can I ensure that the user does not enter a letter "O" instead zero on PowerApps form?  Power Automate flow shows the following error:

 

Error
Action 'Parse_Course_Change_Form_Body' failed
Error Details
The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Input string '0931' is not a valid number. Path 'Phone3', line 1, position 161.'.
 

 

{

    "type": "object",

    "properties": {

        

        "Phone1": {

            "type": "integer"

        },

        "Phone2": {

            "type": "integer"

        },

        "Phone3": {

            "type": "integer"

        },

        "StartDate": {

3 REPLIES 3
Post Prodigy
Post Prodigy

You're in the PowerApps forum 🙂 

 

You could do a condition value with a Contains as the operator. 

 

Solved: Variable Contains String - Power Platform Community (microsoft.com)

Frequent Visitor

Yes,  thank you.    The user entry is done to power apps form, and for some reason does not like Zero when updating SharePoint List.     Any other numbers it has no issue.  

Community Support
Community Support

Hi @DB7 :

Do you want to verify that the user's input is a number?

The key is to use 'Ismatch'.I've made a test for your reference:

1\I assume there is a textinput control(TextInput2) 

set it's OnChange proeprty to:

If(!(IsMatch(TextInput2.Text,"\d*")),Notify("You must enter numbers");Reset(TextInput2))

29.gif

Best Regards,

Bof

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (20,913)