Fix Power Apps Not Showing All SharePoint List Columns
Question details
Users need to display missing SharePoint list columns in automatically generated Power Apps forms to prevent required-field submission errors.

- Product
- Power Apps
- Device & OS
- not provided
- Scenario
- Creating or editing list items using an automatically generated Power Apps form connected to a SharePoint list.
- Observed behavior
- The Power Apps form omits certain SharePoint list columns, which results in required-field errors when users attempt to submit data.
Ensure you have the necessary edit permissions for the SharePoint list and that you are logged into Power Apps Studio with the correct Microsoft account.
Manually Add Missing Columns in Power Apps Studio
Use the Power Apps Studio interface to inspect the form's data cards and manually insert any skipped SharePoint columns.
When Power Apps automatically generates an application from a SharePoint list, it often limits the number of fields displayed by default to optimize initial performance. This can inadvertently leave out required columns, causing errors upon submission. You can resolve this by adding them back manually.
Navigate to the Power Apps portal, select your app, and click 'Edit' to open it in Power Apps Studio.
From the Tree view on the left, expand your screens and select the specific form control (e.g., EditForm or DetailForm) where the fields are missing.
In the Properties pane on the right side of the screen, locate the 'Fields' section and click on 'Edit fields'.
Click the 'Add field' button, check the boxes next to your missing SharePoint columns in the flyout menu, and click 'Add'.
If you need to further customize the newly added fields, select the specific data card, go to the Advanced tab in the Properties pane, and click 'Unlock to change properties'.

Refresh the SharePoint Data Source
Force Power Apps to fetch the latest schema and column structure from your connected SharePoint list.
Discover WPS Office for Seamless Document Management
While resolving Power Apps and SharePoint integration issues can be highly technical, managing your exported lists and daily documents shouldn't be. WPS Office provides a free, lightweight, and user-friendly alternative to Microsoft Office.
- 1. Download the installer: Visit the official WPS Office website to download the free installation package.
- 2. Install the software: Run the setup file and follow the simple on-screen instructions to install the application.
- 3. Open your documents: Launch WPS Office and instantly open your exported SharePoint data or Microsoft Office files without formatting loss.

Frequently Asked Questions
Why does Power Apps omit columns when generating an app automatically?
Power Apps limits the number of fields included in auto-generated forms to simplify the layout and ensure fast initial loading times. Complex columns like lookups, choices, or custom metadata are frequently skipped and must be added manually.
How do I fix a required-field error when submitting a Power Apps form?
To fix this error, open the form in Power Apps Studio, click 'Edit fields', and ensure all columns marked as 'Required' in your SharePoint list are added to the form. Verify that the user provides a valid value for each required data card.
Does refreshing the data source in Power Apps overwrite my custom layout?
No. Refreshing the SharePoint data source only updates the back-end schema to pull in new or modified columns. It does not overwrite or reset the layout, formulas, or customizations you have already applied to the app.
What should I do if a column still doesn't show up after refreshing?
Ensure the column type is supported by Power Apps. Some complex SharePoint column types (like multi-value lookups in certain scenarios) might have limited support. You can also try removing the data connection entirely and re-adding it.




