Others

How to Fix Blank Forms and Required Field Errors in Microsoft Lists

Adam DavisAdam Davis Nov 3, 2026 869 views

Question details

The user needs to resolve an issue where Microsoft Lists displays a blank form upon item creation, and dependent Power Apps dropdown fields fail to update list columns, causing a required info error.

How to Fix Blank Forms and Required Field Errors in Microsoft Lists
Product
Microsoft Lists / Power Apps
Device & OS
not provided
Scenario
Creating a new item in Microsoft Lists using a customized Power Apps form with dependent dropdowns.
Observed behavior
The form appears blank during item creation, dependent dropdown selections do not save to the corresponding list column, and the system throws a 'Required info' error upon submission.
Before you start

Before troubleshooting, ensure you have sufficient Owner or Member permissions to edit the list settings and access the associated Power Apps environment.

Solution 1Recommended

Verify Power Apps Form Configuration and Formulas

Since dependent dropdowns are customized via Power Apps, the blank form and missing data are typically caused by misconfigured default modes or broken data card formulas.

When customizing a Microsoft List form with Power Apps, the integration relies heavily on correct 'Item' and 'Update' properties to pass data back to SharePoint/Lists.

1
Open form customization

Navigate to your Microsoft List, click the 'Integrate' menu at the top, select 'Power Apps', and then choose 'Customize forms'.

2
Check the DefaultMode property

Select the SharePointForm control in the tree view. Ensure the 'DefaultMode' property is set to 'FormMode.New' for new item creation, or that your 'OnNew' property in the SharePointIntegration control is correctly utilizing the 'NewForm(SharePointForm1)' function.

3
Inspect data card Update properties

Select the data card that contains your dependent dropdown. Check the 'Update' property and ensure it points to the selected value of the dropdown control (e.g., 'Dropdown1.Selected.Value'), so the required list column receives the data.

4
Publish and test

Click 'File', then 'Save', and choose 'Publish to SharePoint'. Refresh your Microsoft List and attempt to create a new item to verify the required field error is gone.

Verify Power Apps Form Configuration and Formulas
Data Connection Refresh: If you recently added the required column to your list, remember to refresh the data source in your Power Apps studio so the form recognizes the new field.
Free Microsoft Office alternative

Simplify Data Collection with WPS Spreadsheet and Forms

If complex Power Apps integrations and Microsoft Lists are causing unexpected errors and deployment delays, consider switching to WPS Office. WPS provides an intuitive Spreadsheet tool paired with straightforward form collection features, allowing you to gather and track data effortlessly without writing custom formulas.

  1. 1. Download WPS Office: Install WPS Office Free on your device and launch the application.
  2. 2. Create a new Spreadsheet: Open WPS Spreadsheet to design the layout for the data you want to track.
  3. 3. Utilize WPS Form: Use the integrated Form feature to instantly turn your spreadsheet columns into a shareable questionnaire, capturing responses error-free.
Create and share data collection forms instantly without complex logic configurations.Highly compatible with Microsoft Excel (.xlsx) formats for seamless data management and migration.Lightweight and completely free to use for individuals and small teams.Familiar user interface that requires zero learning curve for Microsoft Office users.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my customized Power Apps form completely blank in Microsoft Lists?

A blank form typically occurs when the SharePointForm control does not have an active record to display. Ensuring the DefaultMode is properly set to FormMode.New or verifying that the SharePointIntegration 'OnNew' property triggers the NewForm() function will resolve this.

Why am I getting a 'Required info' error when submitting my list form?

This error appears when a field marked as required in the Microsoft List settings does not receive a value from the Power Apps form. This usually happens if the Update property of the corresponding data card is left empty or is incorrectly referencing the dependent dropdown's selection.

Can I build conditional dropdowns directly in Microsoft Lists without using Power Apps?

Natively, Microsoft Lists does not support dependent or conditional dropdowns out-of-the-box. You must either use Power Apps to customize the list form or apply complex JSON column formatting to simulate the conditional behavior.