Hi,
The way PowerApps works is that controls don't actively push data into the gallery. Instead the gallery looks at values in the TextInput controls to be filtered. So you would change the Items property of the gallery instead of using the properties of the TextInput controls.
Filter(datasource,
New=TextInput1.Text &&
Old=TextInput2.Text &&
Name=TextInput3.Text &&
Location=TextInput4.Text &&
Email=TextInput5.Text &&
)
This means, "In your gallery, only show records from your datasource where the New column equals what's written in TextInput1.Text, the Old column equals what's written in TextInput2.Text, and so on..."
There's a few variations to this. Instead of the && symbol, you can use a comma for each condition since it's understood as "And." You can also create conditions for each condition. Meaning--maybe you don't want the datasource filtered by all 5 columns all the time. It's unlikely to yield many results that way. You could either use the Search function or more conditions.
Search:
Filter(datasource,
If(!IsBlank(TextInput1.Text),New=TextInput1.Text,true) &&
If(!IsBlank(TextInput2.Text),Old=TextInput2.Text,true) &&
If(!IsBlank(TextInput3.Text),Name=TextInput3.Text,true) &&
If(!IsBlank(TextInput4.Text),Location=TextInput4.Text,true) &&
If(!IsBlank(TextInput5.Text),Email=TextInput5.Text,true) &&
)
This means, "In your gallery, only show records from your datasource where conditions are true for a column when its corresponding TextInput field is not blank." Or in literal terms, "Filter the datasource to show records that return true--If TextInput1 is not blank, then check the New column to see if it equals what's typed in TextInput1."
The Search() function understands that when the TextInput is blank, it won't try to filter, so it can be easier. You would need to nest several of them so that what you type into each TextInput is searched in the corresponding column.
However, if you want to really simplify things, the Search function can be very efficient in terms of coding and user interface. You could reduce the number of TextInput fields to just one. Using the Search function, anything that is typed into that one TextInput field can be compared against as many columns as you would like. To see an example, you could create a new app straight from a datasource and PowerApps will use this setup in its basic template.
Here's an example:
Search(datasource,
TextInput1.Text,
"New",
"Old",
"Name",
"Location",
"Email"
)
This means, "In your gallery, show all records from your datasource where whatever you type in TextInput1 matches any of the 5 columns."
Let me know which method you go with.
