Custom Form - SPACE validation in single text field

[jaina]

Hello Experts,

I have a field called Transport Number, and I configure it to have a maximum length character to 10.

But user is inputting spaces to proceed. How am I supposed to validate the data if with space and less than 10 character, it will prompt an error?

In my submit button, here is my formula so that it will prompt an error and will not be saved

[WarrenBelz · Accepted solution]

Hi @jaina ,

Try OnSelect

If(
   Len(
      Substitute(
         DataCardValuell.Text,
         " ",
         ""
      )
   ) <> 10,
   Notify(
      "Transport Number must be 10 characters long!", 
      Error
   ), 
   SubmitForm(SharePointForm1_NEW_EDIT)
)

and the Update of the Data Card

Substitute(
   DataCardValuell.Text,
   " ",
   ""
)

You will also have to make the maximum characters more than 10 (it is taken care of above)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[jaina]

Hello Sir @WarrenBelz  Thaaaaank you so much! It works!