Using CDS views in Filters

In canvas apps using CDS views are an efficient way of populating collections.

ClearCollect(
    myCollection,
    Filter(
        Entity,
        'Entity(Views)'.'Entity Associated View',
        Status = 'Status (Entity)'.Active
    )
);

In this example we are filtering by the Entity Associated View and that the status is active, when comparing true/false fields or lookup’s you need to use the lookup ‘Status (Entity)’.Active in studio intellisense will provide the options available once you enter, ‘Status (Entity)’. Active or Inactive if its a true/false (2-options) then the options will be Yes or No.

Remember when using views to make sure all the columns you require are included in the view.

Leave a Reply

Your email address will not be published. Required fields are marked *