Show, edit, or add a record from a table in PowerApps
To show all fields in a record, add and configure a Display form control in a canvas app. To edit any field in a record (or to add a record) and save your changes back to a data source, add and configure an Edit form control in a canvas app.
- Learn how to add and configure a control in PowerApps.
- Download this Excel file, which contains sample data for this tutorial.
- Upload the Excel file to a cloud-storage account, such as OneDrive for Business.
- In a new or existing app, add a connection to the FlooringEstimates table in the Excel file.
- If you're using an existing app, add a screen to it.
Add a form, and show data
If you're not sure how to add a control, rename it, or set a property, see Add and configure controls.
The list shows names of flooring products from the data source.
Add an Edit form control, move it below ChooseProduct, and then resize the form to cover most of the screen.
This topic describes the Edit form control, but similar principles apply to the Display form control.
This formula specifies that, after you finish configuring the form, it will show the record that the user selects in ChooseProduct.
In the Data pane, click or tap the checkbox for each field to show it.
If the Data pane is closed, open it by selecting the form in the left-hand pane and then clicking or tapping Data in the right-hand pane.
In the Data pane, drag the Name entry to the top of the list.
The Edit form control reflects your change.
Set the card type for a field
With the form selected, click or tap the card selector for Price in the Data pane.
Scroll down, and then click or tap the View text option to make the field read-only.
The form reflects your change.
(Edit form only) Save changes
In the left-hand pane, select the form, and then click or tap the ellipsis (...).
Click or tap Rename, and then rename the form EditForm.
Set the OnSelect property of the Save button to this formula:
Open Preview mode by selecting the play button near the upper-right corner (or by pressing F5).
Change the name of a product, and then click or tap the Save button that you created.
The SubmitForm function saves your changes to the data source with which you configured the form.
(optional) Select the close icon to close Preview (or press Esc).