cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mminar
Level: Power Up

Data from properly formatted tables in Excel does not show in PowerApps list screen

Hi all:

 

I've recently ran into an issue where data from an Excel 2016 Workbook was not showing up in a PowerApp app.

My Excel workbook consists of four sheets, each with their own (properly formatted) table (verified in Name Manager).

 

To create my problem I did the following:

  1. In Tree View, Data Source > Connectors > OneDrive for Business, then selected my Excel file
  2. Insert > New Screen > List
  3. In Tree View, selected Screen > BrowseGallery
  4. PowerApps now prompts to connect to an existing data source, but you may also be able to select this using the Gallery > Properties > Data source field pane on the righthand side
  5. Data (observations) do not show, but the column headers of my table do.
  6. Tried for other tables in the same Excel workbook, but same problem.

 

My Excel workbook:

  1. Has hidden columns
  2. Comments
  3. Calculated fields (specifically concatenating First Names + Last Names into a Full Name field)
  4. Data validation (pointers to other table columns using the `INDIRECT("TableName[ColumnName]")` method)
1 ACCEPTED SOLUTION

Accepted Solutions
mminar
Level: Power Up

Re: Data from properly formatted tables in Excel does not show in PowerApps list screen

I'm posting my own solution to help anyone with a similar problem in the future.

 

I was able to see my data after I simplified my workbook in Excel. Here is what I did

  • In Excel 2016:
  • Removed calculated fields (I'm still looking for a workaround for this)
  • Executed "check for issues" by going to File > Info > Check For Issues
  • Several problems were noted: I opted to remove comments, hidden columns, etc. All of the aspects now showed a green checkmark.
  • Saved and closed the file
  • In PowerApp:
  • I started a new empty app and proceeded to add a data source: Data sources > Connectors > OneDrive for Business > My Excel Table
  • Then, Insert > New Screen > List
  • Clicking on BrowseGallery in TreeView now prompts for a data connection, and selecting my table now shows the data

View solution in original post

2 REPLIES 2
mminar
Level: Power Up

Re: Data from properly formatted tables in Excel does not show in PowerApps list screen

I'm posting my own solution to help anyone with a similar problem in the future.

 

I was able to see my data after I simplified my workbook in Excel. Here is what I did

  • In Excel 2016:
  • Removed calculated fields (I'm still looking for a workaround for this)
  • Executed "check for issues" by going to File > Info > Check For Issues
  • Several problems were noted: I opted to remove comments, hidden columns, etc. All of the aspects now showed a green checkmark.
  • Saved and closed the file
  • In PowerApp:
  • I started a new empty app and proceeded to add a data source: Data sources > Connectors > OneDrive for Business > My Excel Table
  • Then, Insert > New Screen > List
  • Clicking on BrowseGallery in TreeView now prompts for a data connection, and selecting my table now shows the data

View solution in original post

darrenkemper
Level: Power Up

Re: Data from properly formatted tables in Excel does not show in PowerApps list screen

Closing the spreadsheet and refreshing the data source solved this problem for me.

Helpful resources

Announcements
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (4,779)