Validate Text Input - Add Letter 'U'

[Gina-PowerApps]

Hi there, 

Sorry this is probably a simple fix but I have searched high and low! 

We have a text input control for a Staff Number... all our staff numbers start with U and during testing, some people were only entering the numbers without the U, despite writing 'Include 'U'' on both the question and within the help text. 

Ideally, we would either like to pre-populate the box with U and then they can type their 6 digits, or we need an error message to not letter them submit without a U in the front of the staff number. 

Already have this set up on our submit display mode which greys out the button if they don't have a name or staff number -

If(IsBlank(CrewFirstName.Text) || IsBlank(CrewStaffNo), DisplayMode.Disabled, DisplayMode.Edit)

Would anyone be able to please help either add the U to the front of the text input or add a validation to the submit button, or both please? 🙂 Thanks in advance.

[iAm_ManCat · Accepted solution]

Heya,

Yes, we can use Left() to check whether the first character is a U, like this:

If(
   IsBlank(CrewFirstName.Text)
   || IsBlank(CrewStaffNo.Text)
   || Not(Upper(Left(CrewStaffNo.Text,1))="U"), 
   DisplayMode.Disabled, 
   DisplayMode.Edit
)

Cheers,

[Gina-PowerApps]

Amazing, thank you so much! 

[iAm_ManCat]

Happy to help, have a great rest of the week!