Hi All,
I'm working on the following form which has a data table filtered by 4 combo boxes and a text box.
Each of the combo boxes, except the one highlighted are multi-select, but lookup against single-select fields in Sharepoint. Whereas the highlighted one is a multi-select field in Sharepoint. The code I currently have to filter the data table looks like this.
Can anyone advise how to change the 2 lines in pink at the bottom, so that it will take a multi-select combo and search a multi-select Sharepoint field please?
Filter(
Sort(colIssues,ID,SortOrder.Descending),
(
Len(txt_imtracker_searchtext.Text) = 0 ||
txt_imtracker_searchtext.Text in ID ||
txt_imtracker_searchtext.Text in Title ||
txt_imtracker_searchtext.Text in IssueName ||
txt_imtracker_searchtext.Text in Concat(Current_Assignee,DisplayName,",") ||
txt_imtracker_searchtext.Text in RaiserName.DisplayName
) &&
(
Len(cbo_imtracker_search_status.Selected.Value) = 0 ||
Status in cbo_imtracker_search_status.SelectedItems
) &&
(
Len(cbo_imtracker_search_overallimpact.Selected.Value) = 0 ||
OverallImpact in cbo_imtracker_search_overallimpact.SelectedItems
) &&
(
Len(cbo_imtracker_search_busdatadomain.Selected.Value) = 0 ||
BusDataDomain in cbo_imtracker_search_busdatadomain.SelectedItems
) &&
(
Len(cbo_imtracker_search_critdataitem.Selected.Value) = 0 ||
CriticalDataItem in cbo_imtracker_search_critdataitem.SelectedItems
)
)
Many thanks, Paul
