web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to set validation ...

Power Apps

Answered

How to set validation in field

(0) Share

Report

Report

Posted on by Negi1984

38

Hi All,

I have created a SharePoint list and one of column in it with Security ID and I want to set a validation for the same as per below example in Power App-

1) it should contains 12 character.

2) First 4 character should be first 4 letters of first name. (if first name is less than 4 character than user needs to type "X" to complete 4 characters)

3) middle 4 character should be match with another columns name "Personnel no." last 4 characters

4) last 4 character should be DDMM format. (i.e DD numeric digits should always between 1 to 31 and MM- digits always between 1 to 12")

Can anybody suggest me how to set this validation ?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Negi1984 ,

Could you please share more details about your scenario? When does the validation work?

If you want to validate the Security ID before submitting the form, and these columns mentioned above are all in the form, please try with the following logic.

Len(DataCardValue_SecurityID.Text)=12 && Left(DataCardValue_Name.Text&"XXXX",4)=Left(DataCardValue_SecurityID.Text,4) && Right(Left(DataCardValue_SecurityID.Text,8),4)=Right(DataCardValue_Personnelno.Text,4) && IsMatch(Right(DataCardValue_SecurityID.Text,4),"^([0]?[1-9]|[1|2][0-9]|[3][0|1])([0]?[1-9]|[1][0-2])")

Demo:

Hope this helps.

Sik

Was this reply helpful? Yes No

Join the conversation