Search Char and Colour the whole word?

(0) Share

Report

Posted on by TimmyBoy

997

Hello,

Some while ago i got this great code to colour a part of the text

I like to change it now with a custom part

I have a separated label and i add lets say J

And the name will colour Label13_3 where the J is located or any other Char.

With(
 {
 wMessage: 
 Split(Label13_3," ")
 },
 "<html><head>
 <meta charset='utf-8' />
 </head>
 <body><b>" & 
 First(wMessage).Result & " " & 
 "<b style='background-color:#68FF00;'>" & Index(wMessage,2).Result & "</b>" & " " & 
 Index(wMessage,3).Result & " " & 
 Index(wMessage,4).Result & " " & 
 Index(wMessage,5).Result & "</b>
 </body></html>"
)

So lets say the sample here is John Doe

The above code will colour Doe

And i want to change it with J from the separated label

So how can i make the code colour this part instead so it will always looks for the first part of any word after a space that's contains J or any char i have added?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Make a text input, in my example it is named

TextInput1

Place a label with example text in it to the left of the screen. I set it's text for our example to

"Whether the weather be fine, Or whether the weather be not, Whether the weather be cold, Or whether the weather be hot, We’ll weather the weather, Whatever the weather, Whether we like it or not."

Now on the right of our screen I place an html text box, it's htmltext is set to

"<html> <body> <div align=center>" & Concat( ForAll( Split(Label13_3, " ") As inFocus, If( Len(TextInput1.Text)=0, inFocus.Result, Upper(Left(inFocus.Result,Len(TextInput1.Text)))=Upper(TextInput1.Text), "<font style='background-color:#68FF00; font-weight:bold;'>" &inFocus.Result& "</font>" , inFocus.Result)), ThisRecord.Value, " ") &"</div></body></html>"

In this example you can use the text input to search for words, by typing into it. if you type w it highlights everything that starts with a w like so

furthermore if you add another letter it will narrow further, for example i type a wh and i get the following highlighted.

to change it to 1 letter only you will need to just chaneg the

Len(TextInput1.Text)

in the

Upper(Left(inFocus.Result,Len(TextInput1.Text)))=Upper(TextInput1.Text)

statement to 1, if you do that however be sure to limit their text input to 1 character only

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like
a
(1)

Report
Copy link

Link copied!

@TheRobRush
Omg, you are so amazing,
Thank you so much for this solution
Just what i needed 😉

Was this reply helpful? Yes No