Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Exclude multiple values from the same column in a collection

Hi everyone,


I want to exclude specific values in a column from a collection. In the example below I want to exclude any records with a status of “02. Rejected” and “11. Closed”.




I am aware it is possible to do this by creating a separate collection of the values I want to exclude, and then use that collection as the filter parameter:


ClearCollect(collectExcludedOptions, ["02. Rejected","11. Closed"]);

ClearCollect(FilteredDataSource, Filter(DataSource,Not(Validation_Status in collectExcludedOptions.Value)))


Is there a simpler method? E.g. ClearCollect(FilteredDataSource, Filter(DataSource, Validation_Status NOT {“02. Rejected”, “11. Closed})))


best regards,


Not applicable

Hi @Amik ,


My preference would be using a full collection and apply filter in your gallery. A full collection makes sure you have all the information, but you can process the data using filter in any of your screen, this will save your time and reduce your confusion.

Advocate I
Advocate I

In this context this is not option, because users do not need to see any records with those status types On Start of the app

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,366)