Hello Support,

We have a multiple filter connection (get filter values)
We have a Lookup filter which is filtered using CAML:
<Where>
<Eq>
<FieldRef Name="User" />
<Value Type="Integer"><UserID/></Value>
</Eq>
</Where>

When the SPQUERY result is empty there is no filter value set and all records are shown. And I want to prevent that.
So I tried the "If empty, always fall back to this filter value" option but that does not seem to do anything.
Whether we enable the "Send filter value even if empty" or not.

Please advise.

Kind regards,
Mario

OK. The dilemma was that for the lookup filter we cannot use the "empty" value as default because it will not send filtered values coming from the CAML filter.
And to use "Always fall back to this filter value" we have to choose "Empty" as default value.

We solved it with adding a text filter pointing to the same column with a default value.

Kind regards,
Mario