List view with filter logic does not display correct results to Experience Cloud Site Users

Why This Happens

This is expected behavior if the Experience Cloud site user does not have access to all the fields used in the list view filters. When a user lacks field-level security (FLS) access to one or more filter fields, those filters cannot evaluate correctly, resulting in no results or unexpected results.

Resolution

To view the desired results, the user must have at least Read Only field-level security (FLS) permission on all fields used in the list view filter logic.
To grant field access: Navigate to Setup > Profiles (or Permission Sets) > select the relevant profile or permission set > Field-Level Security for the relevant object. Set all filter fields to Visible for the user's profile or permission set.
If the System Administrator does not want to grant the Experience Cloud site user access to those fields, remove the inaccessible fields from the list view's filter criteria.