Filtering: Multiple filters from same column

[THowkins96]

Hey Wizards,

I am creating a collection based off of multiple variables. My current formula is as below:

OnStart: ClearCollect( BUInfo1, Filter ( 'BU Details (Medium Security)','Closed Date' = Blank() ) )

I want to add in filtering by a column called "Site Type" and to remove all items that are marked as a "Superseded" site type. As I understand it the "<>" function is non-delegable so I need to create multiple "=" functions for all other possibilities. My formula is then as below:

OnStart: ClearCollect( BUInfo1, Filter ( 'BU Details (Medium Security)','Closed Date' = Blank(), 'Site Type'.Value = "Events", 'Site Type'.Value = "Overheads", 'Site Type'.Value = "Reception" ) )

However this formula doesn't create a collection, can someone help advise how I create this collection with the multiple variables for Site Type that I'm after?

Many thanks,

Tom

[v-bofeng-msft · Accepted solution]

Hi @THowkins96 ,

Please try:

ClearCollect( BUInfo1, Filter ( 'BU Details (Medium Security)','Closed Date' = Blank(), ('Site Type'.Value = "Events" || 'Site Type'.Value = "Overheads"||'Site Type'.Value = "Reception") ) )

Best Regards,

Bof

[THowkins96]

Hi Bof,

That has worked! Thank you so much. Just so I understand, the || symbol is the equivalent to using "or", is that correct?

KR

Tom