Power Apps : Filter VS Search VS LookUp functions

Power apps : Understanding What it is and why to use it? – Microsoft  Dynamics CRM/365 by Vishal Grade

Filter function in Microsoft POWER APPS : The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match one or more criteria and to discard those that don’t.

FilterTableFormula1 [, Formula2, … ] )

Lookup  function in Microsoft POWER APPS :The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria.

LookUpTableFormula [, ReductionFormula ] )

Search  function in Microsoft POWER APPS :The Search function finds records in a table that contain a string in one of their columns. The string may occur anywhere within the column

SearchTableSearchStringColumn1 [, Column2, … ] )

Lookup function in microsoft power apps return only a single record value but Search and Filter function in power apps return set of records.

Lets say we have one datasource “Vehicle”

VehicleCapacity
Car4
Truck3
Bus100
Train1000

Filter( Vehicle, Capacity> 4 ) will return

VehicleCapacity
Car4
Truck3

LookUp( Vehicle, Vehicle= “Car”, Capacity) will return 4

Search( Vehicle, “Tr”, “Vehicle” )

VehicleCapacity
Truck3
Train1000

One thought on “Power Apps : Filter VS Search VS LookUp functions”

Leave a Reply