Power Apps Functions – Remove & RemoveIf

There are functions available for deleting or removing records from datasource or table in Microsoft Power Apps.

Remove Function – Use the Remove function to remove & delete a specific record or records from a data source in Microsoft Power Apps.

RemoveIf Function- Use the RemoveIf function to remove & delete a record or records based on a condition or a set of conditions in Microsoft Power Apps.

Below is the datasource & table – “VehicleMaster in Microsoft Power Apps .

VehicleColourSeats
CARRED4
TRUCKBLACK6
BUSBLUE20
FormulaDescription
Remove(VehicleMaster,
First( Filter( VehicleMaster, Colour=”Red” ) ) )
Removes one record from “VehicleMaster” where colour equal to “Red”
Remove(VehicleMaster,
First( Filter(VehicleMaster, Colour=”Red” ) ) First( Filter(VehicleMaster, Colour=”Blue” ) ) )
Removes two records from “VehicleMaster” wher colour equal to “Red” & colour equal to “Blue”
RemoveIf(VehicleMaster, Seats <= 6)Remove all the records from “VehicleMaster” where Seats are less than equal to 6
RemoveIf(VehicleMaster, Seats <= 6, Left(Colour, 1 ) = “B” )Remove all the records from “VehicleMaster” where Seats are less than equal to 6 & colour starts with “B”
RemoveIf(VehicleMaster, true )Remove all the records from “VehicleMaster”

One thought on “Power Apps Functions – Remove & RemoveIf”

Leave a Reply