Customize a SharePoint list form by using PowerApps

You can easily customize the form for a SharePoint list by opening PowerApps in a browser. You don't need to write traditional code, such as C#, or download another app, such as InfoPath. When you publish your changes, the form is embedded within the SharePoint list for use by all of its users. In PowerApps, you can also review analytics reports, easily create conditional formatting, and connect to other data sources.

To follow the steps in this topic, you'll create a simple list so that you can see how customization works, and then you can apply the same concepts to your own list.

Note

If the Customize forms option isn't available or doesn't work correctly for your list, it might contain data types that PowerApps doesn't support. Also, you can't move your form to a different list or environment.

Create a list

On a SharePoint site, create a list, and then add these columns to that list:

  • Details (yes/no)
  • Price (currency)
  • Availability (date without time)
  • Color (choice)

Select Site contents > New > List, type the list name, and select Create. For each column, select Add column, specify the list type (Yes/No, Currency, Date, Choice), specify the list name (Details, Price, Availability, Color), and select Save.

Open the form

  1. In the command bar, select PowerApps, and then select Customize form.

    PowerApps Studio opens in the same browser tab.

  2. If the Welcome to PowerApps Studio dialog box opens, select Skip.

In the command bar, select PowerApps, and then select Customize form. PowerApps Studio opens in the same browser tab. If the Welcome to PowerApps Studio dialog box opens, select Skip.

Move and remove a field

  1. Drag the Availability field to the bottom of the list of fields.

    The fields appear in the order that you specify.

  2. Hover over the Attachments field, select the ellipsis (...) that appears, and then select Remove.

    The field that you specify disappears from the form.

Drag the Availability field to the bottom of the list of fields. Hover over the Attachments field, select the ellipsis (...) that appears, and then select Remove.

Set conditional formatting

You can configure the Price, Availability, and Colors fields to appear only if Details is set to yes.

  1. In the left navigation bar, expand Details_DataCard1, and note the numeral that appears at the end of DataCardValue.

  2. Set the Visible property of the Color, Availability, and Price cards to this formula (replacing, if necessary, the numeral with the one that you noted in the previous step):

    If(DataCardValue2.Value = true, true)

  3. While holding down the Alt key, select the Details toggle (by clicking or tapping it) multiple times.

    The three fields that you configured appear and disappear from the form.

In the left navigation bar, note the numeral that appears at the end of DataCardValue. Set the Visibility property of the Color, Availability, and Price cards to this formula. Hold down the Alt key, and select the Details control multiple times.

Save and publish the form

  1. Open the File menu, select Save, and then select Publish to SharePoint twice.

  2. In the upper-left corner, select the back arrow, and then select Back to SharePoint.

Open the File menu, select Save, and then select Publish to SharePoint twice. In the upper-left corner, select the back arrow, and then select Back to SharePoint.

Further customize your form

  1. Open your list, select New in the command bar, and then select Customize near the top of the form.

  2. Customize your form in a variety of ways, such as those that these topics describe:

    More information: Understand SharePoint forms integration.

Use the default form

  1. From your list in SharePoint, open the settings page (by selecting the gear icon near the upper-right corner), and then select List settings.

  2. Under General settings, select Form settings.

  3. On the Form Settings page, select one of these options, and then select OK.

    • Use the default SharePoint form - When a user opens your list and selects New in the command bar, the default form for the list will appear.

    • Use a custom form created in PowerApps - When a user opens your list and selects New in the command bar, your custom form will appear. (As an alternative, you can publish the form again in PowerApps.)

    You can toggle back and forth between options, as needed.

    Form Settings options

Delete the custom form

  1. From your list in SharePoint, open the settings page (by selecting the gear icon near the upper-right corner), and then select List settings.

  2. Under General settings, select Form settings.

  3. On the Form Settings page, select Use the default SharePoint form, and then select Delete custom form.

    Delete the custom form

Q & A

Forms vs. apps

Q: How does a customized form differ from a standalone app that I create from SharePoint or PowerApps?

A: If you customize the form for a SharePoint list, the form doesn't appear as an app in PowerApps Studio or PowerApps Mobile. You can open the form only from the list for which you created it.

Q: When should I customize a form to manage data in a SharePoint list, and when should I create a standalone app?

A: Customize a form if you want your users to manage data without leaving SharePoint (for example, in a desktop browser). Create an app if you want your users to manage data outside of SharePoint (for example, on a mobile device).

Q: Can I customize a form and create an app for the same list?

A: Yes.

Q: Can I customize a list and create an app using the same features?

A: Yes.

Q: Can I customize a form in an environment other than the default environment in my organization?

A: No.

Manage your custom form

Q: How can I easily share my form with others?

A: Open the form, select Copy link, and then send the link to anyone whom you want to use the form.

Q: Can I update my form without making my changes visible to others?

A: Yes. You can change your form and save as many times as you want, but your changes won't be visible to anyone else unless you select Publish to SharePoint twice.

Q: If I customize a list form and make a mistake, can I revert to a previous version?

A: Yes.

  1. Open your list, select PowerApps on the command bar, and then select Customize forms.

  2. In PowerApps Studio, select File, and then select See all versions. The Versions page opens in a new browser tab.

    Note

    If you don't see the See all versions button, select Save. The button should appear.

  3. Without closing the Versions page or the browser tab, go back to the Save page in the other browser tab, click or tap the arrow at the top of the left navigation pane, and then click or tap Back to SharePoint to unlock your form and close PowerApps Studio.

  4. Go back to the Versions page in the other browser tab, locate the version that you want to restore, and then select Restore.

    Note

    If you get an error message saying that the restore failed because the form is locked by another user, wait until the user unlocks the form, and then try again.

Q: Can I move my form from one list to another?

A: No.

Administer your custom form

Q: How do I share my form?

A: You don't need to share the form—the form inherits permissions from the SharePoint list. When you're done customizing it, just publish it back to SharePoint so that others can use it.

Q: Who can customize forms?

A: Anyone with SharePoint permissions to manage, design, or edit the associated list.

Q: Do I need a PowerApps license to create or use custom list forms?

A: You need an Office 365 plan that includes PowerApps.

Q: What happens when guest users access a list that has a custom form?

A: Guest users get an error message if they try to access a list form that's been customized using PowerApps.

Q: As an administrator, how do I get a list of all customized forms in my organization?

A: If you're a tenant administrator for PowerApps or you have environment-administrator permissions on the default PowerApps environment of your organization, do the following:

  1. In the PowerApps admin center, select the default environment for your organization from the list of environments.

  2. At the top of the default environment page, select Resources.

  3. From the list of apps, look for apps with a SharePoint Form app type—these are the customized forms.

    List of customized forms