RemoveIf

How to Use the Power Fx RemoveIf  Function in Power Apps

What is the RemoveIf function?

The RemoveIf function is a Power Fx function that enables you to remove items from a collection based on a set of conditions. The function takes two arguments: the collection that you want to remove items from, and a formula that specifies the conditions that the items must meet in order to be removed. The function returns a new collection that contains all the items from the original collection that do not meet the specified conditions.

How to use the RemoveIf function

To use the RemoveIf function in Power Apps, you need to follow these steps:

1. Create a collection: The first step is to create a collection that contains the items that you want to remove. You can create a collection by using the ClearCollect function or the Collect function. For example, the following formula creates a collection named “MyCollection” that contains three items:


ClearCollect(MyCollection, {Name: “John”, Age: 25}, {Name: “Jane”, Age: 30}, {Name: “Bob”, Age: 35})


2. Use the RemoveIf function: Once you have created the collection, you can use the RemoveIf function to remove items from the collection based on a set of conditions. The formula that you use with the RemoveIf function must return a Boolean value, which specifies whether an item should be removed or not. For example, the following formula removes all the items from the "MyCollection" collection where the Age is greater than or equal to 30:


ClearCollect(NewCollection, RemoveIf(MyCollection, Age❱=30))


In this formula, the RemoveIf function takes two arguments: the "MyCollection" collection, and the formula "Age❱=30". The formula specifies that the function should remove all the items from the collection where the Age is greater than or equal to 30. The result of the RemoveIf function is then stored in a new collection named "NewCollection".

3. Use the new collection: Once you have used the RemoveIf function to create a new collection, you can use the new collection in your app just like any other collection. For example, you can use the new collection as the data source for a gallery control.

The RemoveIf function is a powerful tool that enables you to remove items from a collection based on a set of conditions. By using the RemoveIf function in Power Apps, you can create custom business applications that are tailored to the needs of your organization. In this article, we have explored how to use the RemoveIf function in Power Apps, and we have seen how it can be used to create a new collection that contains only the items that meet your specified conditions.

Power Apps Training Courses by G Com Solutions (0800 998 9248)