Hello All,
To avoid 'in' delegation issue, I have created a Flexible height gallery which is getting filtered based on 2 dropdown values created in app as filter.
1st dropdown value is Status of request, Second dropdown is Group. The backend data is SharePoint list, and both "Status" and "Group" are single selection choice fields.
Now after filtering and getting this data, I am hiding and showing rows based on Text input field and a Combobox field. Text input field searches the "description" columns in SharePoint which are "TitleDetails" of the request and "DetailedDescription" of the request. I also have a combobox column in SharePoint called "Country" which I want to use to filter along with the textbox field. The code for gallery works fine
If(
drpdwnStatus.Selected.Value = "All",
If(
drpGroupSelection.Selected.Name = "All",
TotalList,
Filter(
TotalList,
GroupName = drpGroupSelection.Selected.Name
)
),
If(
drpGroupSelection.Selected.Name = "All",
Filter(
TotalList,
Status.Value = drpdwnStatus.Selected.Value
),
Filter(
TotalList,
GroupName = drpGroupSelection.Selected.Name,
Status.Value = drpdwnStatus.Selected.Value
)
)
)
There are multiple labels created in this gallery, which I have grouped together and then for the entire group, visible property is added as
If(
IsBlank(txtSearchBox),
true,
txtSearchBox.Text in ThisItem.'TitleDetails' || TextSearchBox_1.Text in ThisItem.DetailedDescription
)
Till this the code works fine. The moment I add the code as below, the gallery goes in error.
If(
IsBlank(txtSearchBox),
true,
txtSearchBox.Text in ThisItem.'TitleDetails' || txtSearchBox.Text in ThisItem.DetailedDescription && Concat(comboBoxCountry.SelectedItems,Value&",") in Concat(ThisItem.Country,Value&",")
)
Can someone please help me how to add the combobox piece to the code for hide/show of gallery rows?
Thanks,
AK