Delegation issue with "In" operator

[muzamil-baxture]

Hi Experts,

I have a combo box whose selected values I am capturing in a variable. I inserted a button and then on select of the button I wrote: 

Set(varcb,ComboBox1.SelectedItems.Result)

For the Items of my combo box : 

ForAll(Split(("All," & Concat( ForAll(Distinct('Production Report_1',Title), {Result: ThisRecord.Value}), Result&",")), ","), {Result: ThisRecord.Value})

Also I have check boxes, for filtering but I am using labels for dynamically getting the text value of those check boxes  and then filtering based on those labels. I want user to have multi select option

the Items property of my gallery I have set as:

If(
    IsBlank(Label23_1.Text) && IsBlank(Label24_1.Text) && IsBlank(Label25_1.Text) && IsBlank(Label26_1.Text) && IsBlank(Label27_1.Text),
    'Production Report_1',
    Filter('Production Report_1',   StartsWith(Studio_1, Label23_1.Text) || StartsWith(Studio, Label24_1.Text) || StartsWith(Studio, Label25_1.Text) || StartsWith(Studio, Label26_1.Text) || StartsWith(Studio, Label27_1.Text) || Title in varcb)
    )

 When the user selects all the items he wants in combo box, I want him to click a button then only the gallery should populate the filtered records, that's why I have used the variable (varcb) to capture the selected items of combo box. But here the issue I am having is of delegation warning because of 'In' Operator. Could you please suggest me any alternative way to avoid delegation issue. Also if I have to use radio button to filter instead of labels, along with combo box how to achieve it. 

@Rusk , @CNT , @Drrickryp  @iAm_ManCat , @BCBuizer  hope you guys will me out.

[BCBuizer]

Hi @muzamil-baxture ,

Please try the below:

UnGroup(
	ForAll(
		ComboBox1.SelectedItems As _Filter,
		Filter(
			'Production Report_1',
			StartsWith(Studio_1, Label23_1.Text) || StartsWith(Studio, Label24_1.Text) || StartsWith(Studio, Label25_1.Text) || StartsWith(Studio, Label26_1.Text) || StartsWith(Studio, Label27_1.Text) ||	Title = _Filter.Result
		)
	),
	"Value"
)

I noticed one condition that mentions Studio_1 as the column name, so that may be a typo on your end?

[muzamil-baxture]

Hey @BCBuizer , Thanks for replying its working fine, but when the user arrives on the screen the gallery is not pre populating when nothing is selected, also if the check boxes are selected they are showing items which are not selected in the combo box

for example if I select two titles in combo box belonging to Disney and if I select Check box for Hulu it is showing me all the records belonging to hulu as well. Is there a way to bind these two conditions ?

I really appreciate your help?

[BCBuizer]

Hi @muzamil-baxture ,

I made some modification in the below formula:

- In case nothing or "All" is selected in the combobox, all items are shown.

- Changed logical operator for the checkbox items from OR to AND

If(
	IsEmpty(ComboBox1.SelectedItems) || "All" in ComboBox1.SelectedItems.Result,
	'Production Report_1',
	UnGroup(
		ForAll(
			ComboBox1.SelectedItems As _Filter,
			Filter(
				'Production Report_1',
				StartsWith(Studio_1, Label23_1.Text) || StartsWith(Studio, Label24_1.Text) || StartsWith(Studio, Label25_1.Text) || StartsWith(Studio, Label26_1.Text) || StartsWith(Studio, Label27_1.Text),
				Title = _Filter.Result
			)
		),
		"Value"
	)
)		

[muzamil-baxture]

@BCBuizer , Its working but not in a way that the requirement is, so here when the user clicks on the check box before selecting anything from the combo box, the gallery should filter and then he will select the titles belonging to that studio. The check boxes are working only after titles are selected in the combo box, if nothing is selected in the combo box, the check boxes are not filtering. 

Note: I am capturing the text of check boxes in the labels and then using those to filter. the formula for text property of my labels is : If(Checkbox1_6.Value = true, Checkbox1_6.Text)

Also wanted to know is there  a  way to capture all the selected items of combo box in a variable and then use that variable on select of a button to show the filtered results.

I mean here when the user arrives on the screen, first he selects the studio from the check box, then the gallery gets filtered. After that he chooses the titles from the combo box for further filtering.

Thanks  

[BCBuizer · Accepted solution]

Hi @muzamil-baxture,

The below will make filtering using the checkboxes also work in case nothing or "All" is selected in the ComboBox:

If(
	IsEmpty(ComboBox1.SelectedItems) || "All" in ComboBox1.SelectedItems.Result,
	Filter(
		'Production Report_1',
		StartsWith(Studio_1, Label23_1.Text) || StartsWith(Studio, Label24_1.Text) || StartsWith(Studio, Label25_1.Text) || StartsWith(Studio, Label26_1.Text) || StartsWith(Studio, Label27_1.Text)
	),
	UnGroup(
		ForAll(
			ComboBox1.SelectedItems As _Filter,
			Filter(
				'Production Report_1',
				StartsWith(Studio_1, Label23_1.Text) || StartsWith(Studio, Label24_1.Text) || StartsWith(Studio, Label25_1.Text) || StartsWith(Studio, Label26_1.Text) || StartsWith(Studio, Label27_1.Text),
				Title = _Filter.Result
			)
		),
		"Value"
	)
)	

If you would like to use a button, you can set its' OnSelect property to:

ClearCollect(
   colFilter,
   ComboBox1.SelectedItems
)

Then substitute any references to ComboBox1.SelectedItems in the filter formula with colFilter

[muzamil-baxture]

@BCBuizer , Now it works perfectly fine without any delegation warning.