Recently, while working on the Power Apps Data table control, I got a requirement to delete rows from the data table control in Power Apps. Read this complete tutorial, where I have explained how to delete rows in Power Apps data table with different examples.
Delete Rows in Power Apps Data Table
While working with Power Apps data table control, sometimes we need to remove some unwanted records or rows, or else if there are any duplicate records in the data table, then you can easily remove or delete those records.
To work around these real-time scenarios, follow the below-mentioned steps.
Scenario-1: Delete Single Row From Data Table
Normally, in Power Apps, there is a Data table control where all the records are retrieved from different data sources, i.e., [SharePoint, Collection, Excel, etc…]. Here, I have taken my SharePoint Online list [Vacation Budget], which contains some records using different columns.
Input:
Now, I want to display these list records on the Power Apps Data table control and remove or delete the selected record. Refer to the screenshot below for the output.
Output:
To achieve it, follow the below steps.
1. Create a Blank Canvas app and connect it to the specific SharePoint Online list [Vacation Budget] like below.
2. Now, select the default screen -> Insert a Data table control and set its Items property as:
Items = 'Vacation Budget'Where,
- Vacation Budget = SharePoint Online List
3. Next, insert a Button control [Delete Selected Row] and set its OnSelect property to the code below.
OnSelect = Remove(
'Vacation Budget',
DataTable_Records.Selected
)Where,
- Remove() = This Power Apps Remove() function is used to remove a specific record or records from a data source
- Vacation Budget = SharePoint Online List
- DataTable_Records = Data table name
4. Once your app is ready, Save, Publish, and Preview the app. Whenever the selects any specific record from the data table and clicks on the button control, it will be deleted or removed from the data table as in the screenshot below.
5. Also, when the user clicks on the button control, it will remove the selected row in the SharePoint list. This lets you delete a row from the Power Apps data table control.