Announcements
in my canvas app i have got datatable. How to edit or delete the line item in the datatable ?
Following formulas in datatable items.
Filter(Dailyinventory, Text('Created On',ShortDate) = Text(Today(), ShortDate))
Data tables are read only. The only way to edit what is displayed in them would to be to have the data stored in a collection or other source and have a separate control edit and save that data
Data Table Control
@AVTS
The simplest way is to put a trashcan icon on the screen and make it's property Remove(yourdatasource,ID=Datatable.Selected.ID).
To edit a record in the datasource, you can use an editform with the DataSource property yourdatasource and the Item property Lookup(yourdatasource,ID=Datatable.Selected.ID).
The edit form doesn't have to be on the same screen. You can put a pencil icon on the screen with the OnSelect property Navigate(youreditformscreen);EditForm(youreditform)). To add a new record to your datatable, put a + icon on the screen and set its OnSelect to Navigate(youreditformscreen);NewForm(youreditform))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 411 Super User 2026 Season 2
Mohsin Ali 338
WarrenBelz 256 Most Valuable Professional
