Unanswered

Conditional formatting

(1) Share

Report

Posted on by amyharkus86

726

I have a text field that i would like to add some conditional formatting, It needs to be formatted for a sort code, xx-xx-xx

for example 12-05-55

How can i do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @amyharkus86 ,
You can try something like below:
With({varT:"123456"},Concatenate(Left(varT,2),"-",Mid(varT,3,2),"-",Right(varT,2)))

Was this reply helpful? Yes No
amyharkus86 726 on at

Like
a
(0)

Report
Copy link

Link copied!

Putting the above as the default on the text input field, only works if the sort code number is 123456, this is not always the case, it would be ##-##-##

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @amyharkus86 ,
If you are using a gallery, you can replace the hardcoded text with dynamic content like below -
With({varT: ThisItem.ColumnName},Concatenate(Left(varT,2),"-",Mid(varT,3,2),"-",Right(varT,2)))
And when the value is blank you can add a condition -
If(IsBlank(ThisItem.ColumnName, "##-##-##", With({varT: ThisItem.ColumnName},Concatenate(Left(varT,2),"-",Mid(varT,3,2),"-",Right(varT,2))))

Was this reply helpful? Yes No
amyharkus86 726 on at

Like
a
(0)

Report
Copy link

Link copied!

@NandiniBhagya20 can it only be done in gallery? i was using EditForm.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Matthew Devaney has a good post covering input masking here:

Power Apps Phone Number Formatting In A Form (Input Mask) (matthewdevaney.com)

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @amyharkus86 ,
You can do this in edit form too. You can add a button that will format the text and on click of the button:
UpdateContext({varText:With({varT:DataCardValue1.Text},Concatenate(Left(varT,2),"-",Mid(varT,3,2),"-",Right(varT,2)))})
Set Default property of DataCardValue1 to
If(Form1.Mode=FormMode.New,varText,Parent.Default)
You can also add validation and check if the text is in proper format by using IsMatch function -
If(IsMatch(DataCardValue1.Text, "\d{2}-\d{2}-\d{2}" ),SubmitForm(Form1),false)

Was this reply helpful? Yes No