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

Unable to see Excel table content in the App

Hi,

As shown in the Excel- Power App video, created an excel sheet in the OneDrive business, connected to it . Excel has Table connected the table and generated the App.

To my surprise the App does not show fileds of Table as shown in the Video like search etc is blank.

Do need to do some other treatment to Excel or why is this a problem..

Excel is connected but it does snot show Fields and values , 1st screen is blan, second screen has Row headings but no values in the APP.

 

Please help

6 REPLIES 6
PowerApps Staff sarafankit
PowerApps Staff

Re: Unable to see Excel table content in the App

Does your excel table has a calculated column? Sadly at this time we don't support calculated columns in Excel and just fail silently without a proper error message.


Can you please try again by removing the calculated column?

Stephix
Level: Powered On

Re: Unable to see Excel table content in the App

Hi

On your sheet's Excel file, have you insert your data into a board ?

heramb
Level: Power Up

Re: Unable to see Excel table content in the App

yes ...

Highlighted
heramb
Level: Power Up

Re: Unable to see Excel table content in the App

What is to be done to enter data in to board ?

What do you mean by Board in Excel ?

 

PowerApps Staff AndyPennell
PowerApps Staff

Re: Unable to see Excel table content in the App

I think "board" means "Table" in this case. Excel data needs to be in tables for PowerApps to consume it. See http://www.wikihow.com/Make-Tables-Using-Microsoft-Excel

Stephix
Level: Powered On

Re: Unable to see Excel table content in the App

Yes that right, not "Board" but "Table",  sorry my excel was in french

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 335 members 6,496 guests
Recent signins:
Please welcome our newest community members: