String Character limitation

[Wolfmeyn]

Hi i have a form on powerapps which is connected to sharepoint.

In that form i have field that is Single line of text which i want to apply some rules on.

Is it possible to create following rules on that field:

RULES:

- EITHER EXACT 11 digits of which the 7th digit is either “-“, “A” or “+” (person)
- OR EXACT 9 digits of which the 7th digit is a “-“ (corporate customer)

 

[developerAJ]

You can check by using this formula.

Or(
And(
Len(TextInput2.Text) = 11,
!IsBlank( Match(TextInput2.Text, "^\d{6}[-A+]\d{4}$").FullMatch)
),
And(
Len(TextInput2.Text) = 9,
!IsBlank( Match(TextInput2.Text, "^\d{6}-\d{2}$").FullMatch)
)
)

Please click Accept as solution and Thumbs Up. 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.

You can connect with me on LinkedIn

@Wolfmeyn

[Wolfmeyn]

Should i use this formula in "On Change" or somewhere else ? 

[developerAJ · Accepted solution]

you can use this to disable the submit button of the form by check 

if(Or(
And(
Len(TextInput2.Text) = 11,
!IsBlank( Match(TextInput2.Text, "^\d{6}[-A+]\d{4}$").FullMatch)
),
And(
Len(TextInput2.Text) = 9,
!IsBlank( Match(TextInput2.Text, "^\d{6}-\d{2}$").FullMatch)
)
),displaymode.edit,displaymode.disabled)

and also if you are using form for datacard you would have a errormessage in datacard control you can make it visible by using below formula on visible property

Not(Or(
And(
Len(TextInput2.Text) = 11,
!IsBlank( Match(TextInput2.Text, "^\d{6}[-A+]\d{4}$").FullMatch)
),
And(
Len(TextInput2.Text) = 9,
!IsBlank( Match(TextInput2.Text, "^\d{6}-\d{2}$").FullMatch)
)
))

for error message text property you can give what you need to display if the user enter wrong format.

Please click Accept as solution and Thumbs Up. 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.

You can connect with me on LinkedIn

[Wolfmeyn]

Where do i paste this formula ?? 

if(Or(
And(
Len(TextInput2.Text) = 11,
!IsBlank( Match(TextInput2.Text, "^\d{6}[-A+]\d{4}$").FullMatch)
),
And(
Len(TextInput2.Text) = 9,
!IsBlank( Match(TextInput2.Text, "^\d{6}-\d{2}$").FullMatch)
)
),displaymode.edit,displaymode.disabled)

[developerAJ]

As mentioned Submit button which you are using to submit the form display mode

[Wolfmeyn · Accepted solution]

I modified it and used it "On Change" it works thanks

If(Or(
And(
Len(CustimerIDFI.Text) = 11,
!IsBlank( Match(CustimerIDFI.Text, "^\d{6}[-A+]\d{4}$").FullMatch)
),
And(
Len(CustimerIDFI.Text) = 9,
!IsBlank( Match(CustimerIDFI.Text, "^\d{6}-\d{2}$").FullMatch)
)
), true, Reset(CustimerIDFI))

[Wolfmeyn]

How do i change it to mix between characters and digits. So that the rule is:

RULES:

- EITHER EXACT 11 characters/numbers of which the 7th digit is either “-“, “A” or “+” (person)
- OR EXACT 9 characters/numbers of which the 7th digit is a “-“ (corporate customer)

[Wolfmeyn]

The current solution works only for numbers(123456-1234), how do i make it work for mix between numbers and letters (12345K-123K)

If(Or(
And(
Len(CustimerIDFI.Text) = 11,
!IsBlank( Match(CustimerIDFI.Text, "^\d{6}[-A+]\d{4}$").FullMatch)
),
And(
Len(CustimerIDFI.Text) = 9,
!IsBlank( Match(CustimerIDFI.Text, "^\d{6}-\d{2}$").FullMatch)
)
), true, Reset(CustimerIDFI))