Thank you for visiting my site!

Home / PowerApps - Forms / Validate Input – Dropdowns, date pickers, and Text Inputs

Validate Input – Dropdowns, date pickers, and Text Inputs

Based on Video:

To delay the output set the inputbox “DelayOutput property to true


Formulas:

Get the value of a number

If(
Value(input1.Text) >= 100 And Value(input1.Text) < 200,
“yes”,
“no”
)

If((1=1 Or 2=2) And 3=3, “yes”, “no”)


Check the Number of Characters entered

Len(input1.Text)

If(Len(input1.Text)> 3 , “yes”, “no”)


Email

If(IsMatch(inputBox.Text, Email), “yes”, “no”)

IsMatch(textInput.Text, User().Email, MatchOptions.Complete & MatchOptions.IgnoreCase) //MatchOptions.Complete = exact match

If(Lower(User().Email) = Lower(textInput.Text), “yes”, “No”)


PhoneNumber Match:

(334) 567-6666

If(IsMatch(inputBox.Text,LeftParen & Digit & Digit & Digit & RightParen & Space & Digit & Digit & Digit &Hyphen&Digit&Digit&Digit&Digit),”yes”,”no”)

(334) 567-6666 Or (334)567-6666 with no space

If(
IsMatch(
inputBox.Text,
LeftParen & Digit & Digit & Digit & RightParen & Space & Digit & Digit & Digit & Hyphen & Digit & Digit & Digit & Digit
) Or IsMatch(
inputBox.Text,
LeftParen & Digit & Digit & Digit & RightParen & Digit & Digit & Digit & Hyphen & Digit & Digit & Digit & Digit
),
“yes”,
“no”
)

 

If(IsMatch(textInput.Text, “Abc”, Contains & IgnoreCase), “yes”, “No”)


Hide a button if text box and dropdown is blank

If(IsBlank(textInput.Text) Or IsBlank(Dropdown1.Selected.Value), Disabled, Edit)

Disable a button if dropdown is Other and text box is empty

  1. Reset the text box each time user reselect the dropdown: onSelect = Reset(textInput)
  2. hide the text input ,  Visible property = Dropdown1.Selected.Value = “Other” // no ifs, it returns true or false
  3. set the button DisplayMode=
    If(
    IsBlank(Dropdown1.Selected.Value )
    Or (textInput.Visible And IsBlank(textInput.Text)),
    Disabled,
    Edit
    )

To type an emoji

in the text box press the window key and a dot


Dates:

is the date older than 18 years? ” & If(
DatePicker1.SelectedDate < DateAdd(Today(), -18, Years),
“yes”,
“no”
)

Is the date within the next 30 days? ” &
If(
DatePicker1.SelectedDate >= Today()
And
DatePicker1.SelectedDate < DateAdd(Today(),30,Days),
“yes”,
“no”
)

Did they choose a weekday? ” &
If(
Weekday(DatePicker1.SelectedDate, Monday) < 6,
“yes”,
“no”
)

ADD YOUR COMMENT