Power Platform Community Forum Thread Details

Hi everyone,

I’m working on a Power Apps app connected to Dataverse and I’m stuck on a filtering formula.

Scenario:
- Table: 'Catalogue produit'
- Field 'TEST ENTITE (Catalogue produit)': multi-select choice field
- Field 'Campagne (Catalogue produit)': choice field (but I also tried as if it were text)
- Variable `varEntité`: contains the entity I want to filter on

Goal:
I want a ComboBox to display all distinct values of 'Campagne (Catalogue produit)' from records where 'TEST ENTITE (Catalogue produit)' contains the value in `varEntité`.

What I tried:

1.
Distinct(
    Filter(
        'Catalogue produit';
        varEntité in Value('TEST ENTITE (Catalogue produit)')
    );
    'Campagne (Catalogue produit)'
)
This runs without errors but returns only one value instead of multiple.

2.
Tried adding `.Value` to 'Campagne (Catalogue produit)' in the Distinct, but I get
"The name isn’t valid. Value isn’t recognized."

3.
Tried using:
!IsEmpty(
    Filter(
        'TEST ENTITE (Catalogue produit)';
        Value = varEntité
    )
)
but I get delegation warnings and still couldn’t make `.Value` work reliably.

Issue:
I can’t find a way to:
- Properly filter a Dataverse multi-select choice field by a variable value (`varEntité`)
- Return all distinct 'Campagne' values from those filtered records without errors

Has anyone solved a similar case? Any example formula that works with Dataverse multi-select choice fields would be greatly appreciated.

Thanks!

Categories:

Error handling