SharePoint Document Issues

Fix Power Apps Not Showing All SharePoint List Columns

Huma Ashraf ChHuma Ashraf Ch Oct 22, 2026 868 views

Question details

Users need to display missing SharePoint list columns in automatically generated Power Apps forms to prevent required-field submission errors.

How to Fix Power Apps Not Showing All SharePoint List Columns
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the app in Power Apps Studio

Navigate to the Power Apps portal, select your app, and click 'Edit' to open it in Power Apps Studio.

2
Select the form control

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.

3
Edit fields

In the Properties pane on the right side of the screen, locate the 'Fields' section and click on 'Edit fields'.

4
Add the missing columns

Click the 'Add field' button, check the boxes next to your missing SharePoint columns in the flyout menu, and click 'Add'.

5
Unlock data cards if needed

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'.

Manually Add Missing Columns in Power Apps Studio
Required Fields: Make sure that the 'Required' property of the data card matches the requirement level set in your SharePoint list to avoid further submission conflicts.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website to download the free installation package.
  2. 2. Install the software: Run the setup file and follow the simple on-screen instructions to install the application.
  3. 3. Open your documents: Launch WPS Office and instantly open your exported SharePoint data or Microsoft Office files without formatting loss.
Highly compatible with Microsoft Excel, Word, and PowerPoint formats.Easily view, edit, and manage exported SharePoint list data in WPS Spreadsheet.Free and lightweight suite tailored for everyday office tasks.Familiar user interface ensuring a seamless migration with zero learning curve.
microsoft office alternative - wps office

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.