Others

Fix Required SharePoint Fields in a Customized Power Apps Form

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

The user needs SharePoint columns marked as optional to be optional in a customized Power Apps form.

Product
Microsoft Power Apps and SharePoint Lists
Device & OS
not provided
Scenario
A SharePoint list uses a customized Power Apps form after some columns were changed from required to optional.
Observed behavior
The customized form still displays required asterisks and blocks submission when the fields are blank, while Quick Edit permits blank values.
Before you start

Confirm which columns were changed to optional and identify the customized form used by the list. In SharePoint, open the list and select Integrate > Power Apps > Customize forms to inspect it.

Solution 1Recommended

Refresh the SharePoint data source and check form validation

Use this approach when optional SharePoint columns are still treated as required in the customized form.

1
Check the column settings

In the SharePoint list, open Settings > List settings, select each affected column, and confirm that requiring the column to contain information is set to No.

2
Refresh the data source

Open Integrate > Power Apps > Customize forms. In Power Apps Studio, open the Data pane, select the ellipsis next to the SharePoint list data source, and choose Refresh.

3
Inspect the data cards

Select the form and each affected data card in the tree view. Use the property selector and formula bar to inspect the card's Required property and any formulas controlling the asterisk or validation message.

4
Review submit formulas

Select SharePointIntegration and inspect its OnSave property. Also check any custom submit button's OnSelect formula for IsBlank checks or other conditions that prevent submission when the affected fields are empty.

5
Re-add a field if needed

If a card still uses outdated settings, select the form, open Edit fields, remove the affected field, and add it again. Review any custom formulas on the card before removing it, since re-adding the field can discard those customizations.

6
Publish and test

Save the form and select Publish to SharePoint. Return to the list, open the customized form, leave the affected fields blank, and submit a test item.

Get formula-specific help: If the form still blocks submission, share the relevant Required, OnSave, and custom button formulas in the Power Apps Community, without including sensitive data.
Free Microsoft Office alternative

Use WPS Office for Everyday Documents and Spreadsheets

WPS Office is a free, lightweight alternative for working with Office documents in a familiar interface. It supports common Microsoft Office formats for a straightforward transition, but it does not fix SharePoint or Power Apps form validation.

Review list data exported to a spreadsheetWork with Microsoft Excel XLSX, Word DOCX, and PowerPoint PPTX filesUse a familiar interface for documents, spreadsheets, and presentationsGet a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does Quick Edit allow blanks while the Power Apps form does not?

The customized form can have its own required settings or validation formulas. Check the affected data cards' Required properties and the form's submit logic in Power Apps Studio.

How do I refresh a SharePoint list in Power Apps Studio?

Open the Data pane, select the ellipsis next to the SharePoint list data source, and choose Refresh.

Will removing and re-adding a field erase its custom formulas?

It can discard customizations on the removed data card. Review the card's formulas before using the form's Edit fields panel to remove and re-add it.

Why is a required asterisk still visible after I make a column optional?

The asterisk may be controlled by a formula on the card. Select the asterisk control in Power Apps Studio and inspect its Visible property, then check the data card's Required property and submit logic.

How do I make the updated form available in SharePoint?

After making changes in Power Apps Studio, save the form and select Publish to SharePoint. Then open the list form and test submission with the optional fields blank.