Hi @Anonymous ,
OK, obviously the formula isn't delegable because of the in operator, not to mention, you have 11K rows data, so I suspect that it's a delegation issue. What you filter exceed the maximum threshold (2000), the gallery only shows blank.
If my assumption is correct, here is a workaround for this issue.
1. set OnChange property of "Filter agreementarea" combox as follows, save each selected option into variable.
Concurrent(
Set(
v1,
Last(
FirstN(
Self.SelectedItems,
1
)
).Value
),
Set(
v2,
Last(
FirstN(
Self.SelectedItems,
2
)
).Value
),
Set(
v3,
Last(
FirstN(
Self.SelectedItems,
3
)
).Value
),
Set(
v4,
Last(
FirstN(
Self.SelectedItems,
4
)
).Value
),
Set(
v5,
Last(
FirstN(
Self.SelectedItems,
5
)
).Value
)
)
2. modify the Gallery.Items property as follow, remove In operator, change to user = operator to match each criterion.
If('Toggle'.Value;
Filter(
Sort('Logg';'Last contact';Ascending);
Agreementarea.Value = "Location1" ||
Agreementarea.Value = "Location2";
Status.Value = "Ongoing" ||
Status.Value = "Finished"
);
Filter(
Sort('Logg';'Last contact';Ascending);
Agreementarea.Value = v1 || Agreementarea.Value = v2 || Agreementarea.Value = v3 || Agreementarea.Value = v4 || Agreementarea.Value = v5 ||;
Status.Value = "Ongoing" ||
Status.Value = "Finished"
))
Hope this helps.
Sik
