This Microsoft Power Apps tutorial will teach us how to remove a SharePoint list item from the Power Apps Gallery. Then, we will discuss the Remove() function to remove the SharePoint list item from the Power Apps Gallery control.
Additionally, we will see how to use the RemoveIf() function to remove a specific SharePoint list item from the Power Apps Gallery.
Delete a SharePoint list item from Power Apps Gallery
Here, we will discuss how to delete a SharePoint list item from the Power Apps gallery.
Example:
I have a SharePoint Online list, i.e., [Issue Traker] and this list contains the below fields.
| Column Name | Data Type |
| Issue Title | Default single line of text column |
| Product Name | A single line of text column |
In Power Apps, there is a Gallery control that is connected to the SharePoint list. When a user removes an item from the Power Apps gallery, it will also be removed from the SharePoint list.
Refer to the below screenshot:
To achieve the above example, follow the below steps.
1. Open Power Apps -> Create Power Apps Canvas app -> Connect to the SharePoint list to the app like below.
2. On the Power Apps Screen -> Insert a Gallery control and set its Items property as:
Items = 'Issue Tracker'Where,
- ‘Issue Tracker’ = SharePoint Online List
3. Insert a Trash icon inside the gallery control and set its OnSelect property code like below.
OnSelect = Remove('Issue Tracker',ThisItem)Where,
- Remove() = This Power Apps Remove() function is used to remove a specific record or records from a data source
- ‘Issue Tracker’ = SharePoint List
- ThisItem = We can select a specific item that we want to remove from the SharePoint list
4. Save, Publish, and Preview the app. Whenever the user clicks on the Trash icon, it will remove the SharePoint list item from the Power Apps gallery, as in the screenshot below.
This is how to remove a SharePoint list item from the Power Apps gallery.
Remove Specific SharePoint List Item from Power Apps Gallery
Next, we will see how to remove a specific SharePoint list item from the Power Apps Gallery using the RemoveIF() function.
Example:
I will also use the SharePoint list [Issue Traker] for this example. I have Gallery control in Power Apps, having the SharePoint list records.
Now, I want to remove specific SharePoint items based on the value, i.e., [Laptop] from Power Apps gallery control, as in the screenshot below.