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)’.
Inactive if its a true/false (2-options) then the options will be
Remember when using views to make sure all the columns you require are included in the view.
Was this helpful?
0 / 0