Fix Required SharePoint Fields in a Customized Power Apps Form
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

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.




