I am trying to create a search in Power Apps Canvas. I need it to search 3 columns with the SharePoint list I have connected to Power Apps. I created a gallery rather than a data table in power apps canvas to house the search with a Text Input box. I tried 2 formulas:
Filter(
'Pre-Clinical Support Request Tool',
TextInput6.Text = "" ||
Search(ProjectName, TextInput6.Text) ||
Search(ProjectDescription, TextInput6.Text) ||
Search(Text(RequestID), TextInput6.Text)
)
or
Filter(
'Pre-Clinical Support Request Tool',
IsBlank(TextInput6.Text) | |
StartsWith(Project Name,TextInput6.Text) ||
StartsWith(Project Desciption,TextInput6.Text) ||
StartsWith(Text(RequestID),TextInput6.Text)
)
The double pipe || has a squiggly line under it in the expressions with unexpected characters error. Is it a spacing issue? Is the formulas not valid?
