Hello, I'm trying to create a module finder for our training products. I've been able to set up a SharePoint list with all of the module details and a search function within the App so trainees can search for the name of the course or the business area - see below image (some words have been redacted for privacy).
This is currently how the search function is operating:
I would like to know if there's a way that I can set up the search function to search all of the words in the title? So for example, they can still find "Entitlement Statements" by typing in "Statements" in the search bar.
The modules are set up as a gallery and this is the code I currently have in place:
If(
galFilterCategories_1.Selected.Value = "All",
Filter(
Training,
StartsWith(
Title,
tbSearchTraining_1.Text
) Or
StartsWith(
Service,
tbSearchTraining_1.Text
)
),
Filter(
Training,
Service = galFilterCategories_1.Selected.Value,
StartsWith(
Title,
tbSearchTraining_1.Text
)
)
)
'Title' and 'Service' are two of my columns in my SP list. galFilterCategories_1 is each of our individual services blanked out at the top. tbSearchTraining_1 is my search bar.
Any help is greatly appreciated!
