Hi @Kumar9024021 ,
Could you please share a bit more about your scenario?
Do you want to search your Gallery Items based on multiple search keywords typed within the "Search Request" part?
If you want to search your Gallery Items based on multiple search keywords typed within the "Search Request" part, I afraid that the single one searchTerm variable could not achieve your needs.
As an alternative solution, I think the combination of If function and Filter function could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:
Set the Items property of the Gallery to following:
Filter(
'DataSource',
If(
IsBlank(EventNameTextBox.Text),
true,
EventNameTextBox.Text in Event
),
If(
IsBlank(SubmittedByTextBox.Text),
true,
SubmittedByTextBox.Text in 'Submittd By' // If the 'Submitted By' is a Person colum (System field in SP list) in a SP list, please type SubmittedByTextBox.Text in 'Submittd By'.DisplayName here
),
If(
IsBlank(EventFtomDTPicker.SelectedDate),
true,
'Event From Dt' = EventFtomDTPicker.SelectedDate
),
If(
IsBlank(EventLocationTextBox.Text),
true,
EventLocationTextBox.Text in 'Event Location'
),
If(
IsBlank(EventOrganizerTextBox.Text),
true,
EventOrganizerTextBox.Text in 'Event Organizer' // If the 'Event Organizer' is a Person column in a SP list, please type EventOrganizerTextBox.Text in 'Event Organizer'.DisplayName here
),
If(
IsBlank(StatusTextBox.Text),
true,
StatusTextBox.Text in Status // If the Status is a Choice type column in a SP List, please type StatusTextBox.Text in Status.Value here
),
If(
IsBlank(EventToDatePicker.SelectedDate),
true,
'Event To Date' = EventToDatePicker.SelectedDate
),
If( // If there is no field related to the PageSizeDropdown box existed in your data source, please ignore this If formula part
IsBlank(PageSizeDropdownBox.Selected.Value),
true,
'Page Size' = PageSizeDropdownBox.Selected.Value
)
)
If you want to display the search results within the Gallery after you click the "Search" button, please consider take a try with the following workaround:
Set the OnSelect property of the "Search" button to following:
ClearCollect(
FilterResults,
Filter(
'DataSource',
If(
IsBlank(EventNameTextBox.Text),
true,
EventNameTextBox.Text in Event
),
If(
IsBlank(SubmittedByTextBox.Text),
true,
SubmittedByTextBox.Text in 'Submittd By' // If the 'Submitted By' is a Person colum (System field in SP list) in a SP list, please type SubmittedByTextBox.Text in 'Submittd By'.DisplayName here
),
If(
IsBlank(EventFtomDTPicker.SelectedDate),
true,
'Event From Dt' = EventFtomDTPicker.SelectedDate
),
If(
IsBlank(EventLocationTextBox.Text),
true,
EventLocationTextBox.Text in 'Event Location'
),
If(
IsBlank(EventOrganizerTextBox.Text),
true,
EventOrganizerTextBox.Text in 'Event Organizer' // If the 'Event Organizer' is a Person column in a SP list, please type EventOrganizerTextBox.Text in 'Event Organizer'.DisplayName here
),
If(
IsBlank(StatusTextBox.Text),
true,
StatusTextBox.Text in Status // If the Status is a Choice type column in a SP List, please type StatusTextBox.Text in Status.Value here
),
If(
IsBlank(EventToDatePicker.SelectedDate),
true,
'Event To Date' = EventToDatePicker.SelectedDate
),
If(
IsBlank(PageSizeDropdownBox.Selected.Value),
true,
'Page Size' = PageSizeDropdownBox.Selected.Value
)
)
)
Then set the Items property of the Gallery to following:
FilterResults
Please consider take a try with above solution, check if the issue is solved.
Best regards,
