cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sam12122
New Member

words validation for a Text Box

I have import my dictionary to power app as list about 8000 words

sam12122_0-1643179828730.png

sam12122_1-1643179997430.png

if my dictionary is 'abcd' and my textbox is 'abcd123'
how can I find value in textbox
I had try Match  

 

6 REPLIES 6
eka24
Super User
Super User

You can validate using the Fill color of the TextBox:

If(Self.Text exactin TableName.Column,Green,Red)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

Thank you for your answer,
there is a problem,
if my dictionary is 'abcd' and my textbox is 'abcd123'
it will not turn red

eka24
Super User
Super User

From your description  'abcd' is not same as 'abcd123' so turning red is ok.

You can change the formula to:

If(Self.Text in TableName.Column,Green,Red)

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

 

Oh sorry I type wrong, 
It will not turn green. 

sam12122_0-1643184512291.png

 

eka24
Super User
Super User

Kindle show the your formula, also screenshot of your table column with the "abcd".

It not clear to me what you want to do with 'abcd' and 'abcd123'

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

 

 

 

I want do a Illegal words validation when user typing password 

sam12122_0-1643188008091.png

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,568)