Creating Records with Power Apps New Form Mode

In this tutorial, you’ll learn how to use the New Form Mode in Power Apps’ Edit Form control to insert new records into a data source.

In this walk through you’ll configure the form, customize its fields, and save data.

In this example we’ll use Microsoft Dataverse as the data source, although another could be used such as Sharepoint and others.

What Is the New Form Mode?

The New Form Mode is a configuration setting for the EditForm control in Power Apps. When set to FormMode.New, the form is prepared to insert new records into the connected data source.

Modes available in EditForm:

• FormMode.Edit – Update an existing record
• FormMode.New – Insert a new record
• FormMode.View – View a record without editing

Step-by-Step Example

1. Create the App and Data Source

Start by creating a Power Apps app—such as a bookstore app—and a Dataverse table named Books. This table should include fields like Title, Author, Publisher, and Year.

2. Insert the Edit Form

Select a container in your app and insert an EditForm control. Set its data source to the Books table. The form will automatically populate with fields from the table.

3. Customize the Fields

• Click Edit Fields in the form control.
• Remove unnecessary fields.
• Resize and reorder fields for better layout (e.g., place Author below Title).

4. Add a Save Button

Insert a button labeled Save. Set its OnSelect property to:

SubmitForm(Form1)

This will submit the form data to the Dataverse table.

5. Set the Form Mode

By default, the form is in Edit mode, which requires an existing item to display. To insert new records, change the form’s DefaultMode property to:

FormMode.New

6. Final Touches

• Use Width Fit to make fields span the full width of the container.
• Apply a theme and align fields for a polished look.

Testing the Form

Play the app and enter sample data:

• Title: My Favorite Book of the Year
• Author: Smart Writer
• Publisher: All Over Books
• Year: 2027

Click Save. Then, refresh the Dataverse table to confirm the new record has been inserted successfully.

Conclusion

The New Form Mode in Power Apps is a fast and simple way to create user-friendly forms for inserting data into your data source tables. With just a few configuration steps, you can build dynamic apps that streamline data entry and improve user experience.