Answered

Checking if values in split string exist in table

(0) Share

Report

Posted on by fuentert94

Essentially, a user provides a string into a textInput box, and after clicking a button, checks if any of the inputted values exists in a specified table. If the values does exist, it should append a value from the table to a new string. The result is then displayed to the users.

The string would look like this: "Amy, Josh, John, Adam"

The table would look like this, and let's name it Sample_Data (Dataverse table):

Name 1	Name 2
Arnold	Smith
Josh	Man
Josh	Cruise
Amy	Woman
Charles	Name

So the resulted string would look like this:

"Josh Man

Josh Cruise

Amy Woman"

I've started the below code, but maybe it's because I'm thinking about this like how I would approach this in things like C++ or Java, but I'm struggling to get it to translate in the onclick function in the button:

//userInput is the name of text box the user types the string in

Set(parseString, userInput.Text);

Set(parseTable, Split(parseString, ", "));

Set(resultString, "");

// Loop through each entry in the split string and append matching entries to the result table

ForAll(

parseTable,

If(

!IsBlank(Filter(Sample_Data, 'Name 1' = Value)),

ForAll(

Filter(Sample_Data, 'Name 1' = Value),

Concat(resultString, Value.'Name 1', " ", Value.'Name 2', "\n" )

))

);

The reason for the double ForAll is because, in case the If fails and the value isBlank, I may still add the value to the string, but concat something like " - doesn't exist" to the value of the name. Any help would be appreciated, I'm sure I'm just thinking about this more like a traditional programmer and not like a PowerApps one. I'm still relatively new to PowerApps, so I'm sorry if I'm missing something simple.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RogierE 879 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I guess PowerApps Fx is a bit less stict. 🙂
Good to know:
- PowerApps has collections and variables. Very close relatives, but collections are easier for manipulating tabular data
- ForAll loops do not work with variables, so better use a collection for that
- But Concats are less strict, so in fact you don't need the ForAll 😄
- Best practice is to start variable names with var and collections with col.

So in short, and far shorter than you proposed, your code could be:
//userInput is the name of text box the user types the string in
Set(varParseTable, Split(userInput.Text, ", "));

// Loop through each entry in the split string and append matching entries to the result table
Set(varResultString,Concat(Filter(Sample_Data,'Name 1' in varParseTable),'Name 1'&" "&'Name 2'&Char(13)))

As the concat works on multiple rows, entering Josh will give you a string with 2 lines. And by using the 'in' statement in the Filter, I don't need to loop through the varParseTable.

Please LIKE the reply and ACCEPT it as the solution if the answer is what you were looking for.
(to help me grow in community rank and help others find the solution)

Was this reply helpful? Yes No
fuentert94 6 on at

Like
a
(1)

Report
Copy link

Link copied!

I had no idea you can use the Concat function like that! This is exactly what I needed. I definitely was overthinking the problem. Thank you so much!

Was this reply helpful? Yes No