Unanswered

Check if string is existing in a data source and substitute it in a text label

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good day,

I have a data source and a column name "animals" that contains cat,dog,fish,bird and I have a text input where the user can type in words.

I want to substitute only the word "cat,dog,fish,bird" that exist in my data source column name if the user types in for a example "The cat is big" and turn it into and display into a text label "The boy is big" .

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Not sure if this is what you mean but with a TextInput box and a label,

Switch(TextInput1.Text,"fish","boy","bird","girl","dog","fido","cat","midnight")

For a dropdown, the label would be:

Switch(Dropdown1.Selected.Value,"fish","boy","bird","girl","dog","fido","cat","midnight")

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp .Thank you for your response, but is there a way to check if the inputted text has a match with the data source?

For example, the data source name would be "Animals" and it contains "dog, cat, bird, lion, fish, etc." and a text input. For example a user paste a word in the text input like "The dog is small" is it possible to automatically validate if a word is existing in the data source "Animals" and change/substitute it if its existing like "The boy is small".

Was this reply helpful? Yes No