Searching through a list.

[EMA03356]

I would like to search all of the columns that I have in a list in SharePoint. I know that I can't search choice and lookup fields with the search function. Can I create a text field in sharepoint that pulls all of the column information into one column as "keywords" like a hidden text field to just search? 

[mmollet]

Yeah this would be the same idea as someone making a field for AddressLabel that combines address, city, state, zip or combining firstname and lastname columns into [lastname, firstname] format. I would make sure that you add a space between each filed rather than smashing them all together as you dont want to create words that dont actually exist in the table by doing so.

One bit of advice would be to let the power app do this for you rather than using calculated columns in sharepoint. One of the main commandments if you will is to never use complex columns in a sharepoint list you are using with a power app. This is b/c they make everything much more difficult. If you have a choice column simply use a text column and then give the choices in the app by using a dropdown menu with only those choices. You are limiting the users input in the same way but keeping your data source clean and easy to use. The same goes for this. You can just use a patch function with a giant concatenate function to push the search value to SP rather than using a complex column. 

Patch(YourList, {...other fields..., SearchField: Concatenate(field1.selected.value, " ", field2.text, " ", field3.text, " ", etc...)});

After this you have a text (or multiline text) column which you can now just search through as needed. You could also just check each column if they were all simple column types.