Power Platform Community Forum Thread Details

Hi Community

I have an existing app and on one of the pages it has a simple table with search box attached to it. Suddenly users can only see two columns of data. The table is populated from a SP list and the users have access permission to the list at contribute level?

Has anyone experienced anything list this especially as it was working before and now its not?

Categories:

Building Power Apps

@Kmayes

This issue—where only two columns are visible in a table that previously showed more—is likely due to one of the following causes:

1. View Configuration Changed
If the table is using a SharePoint view or a custom gallery/table control in Power Apps, someone may have accidentally modified the view or the control’s layout.

Check the gallery or data table control in Power Apps:
- Are all columns still selected in the Fields pane?
- Has the Visible property of any column been changed?
- Has the Width of the control or columns been altered?

2. SharePoint List Column Permissions or Visibility
Even with Contribute permissions, if column-level security or content types were recently introduced or modified, some columns might be hidden.

Check if any new content types or column-level permissions were applied.
Ensure the columns are not marked as hidden in the list settings.

3. Power Apps Formula Changes
If the table is populated using a formula like:
...and the formula was recently changed, it might be limiting the fields returned. Also, check if the Fields property of the control was modified to only show two columns.

4. Data Source Refresh
Sometimes, Power Apps caches schema. If the SharePoint list was modified (e.g., columns renamed or deleted), the app might not reflect those changes until the data source is refreshed.