Excel table not being added properly

[BaldgytAgain]

Trying out powerapps:
l have an excel sheet on my business one drive with a single table of 17 columns and 134 rows. When I connect it to an app either manually or via the create Omedrive phone app wizard I get a connection, it picks up the field names (column headings from the table) but I get no error but I get no data.
I notice that no _powerappsId_ column is created in the sheet.

I have tried renaming all the columns to simple text (no spaces)
I have copied the data out of the sheet into a new sheet so that there is only a table. but no luck. Other small test tables seem to work.

(There is also some odd lag going in that If I create a new table on my web view of one drive - say by copying it does not appear if I try to connect to it from an existing app. I assume this is a known thing but. I do have a lot of data syncing going on).

Is there a place where I might see an error message e.g. a log from the wizards or something from the connector?

[Drrickryp]

Hi @BaldgytAgain 

Is the data in the sheet formatted as a Table in Excel? 

[eka24]

Refresh the connection.

If it does not work, remove the connection and reconnect again.

Are you viewing the data in the table through a gallery?

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[BaldgytAgain]

Yes - and the table name appears in the item for the gallery - and the field names appear in the fields list.

I made very simple sheet with a tabel called Tbale1 and columns named A through R (18) with 40 rows of random integers.  Fails but no error message

The gallery item shows (correctly)
SortByColumns(Search([@Table1], TextSearchBox1.Text, "A","B","C"), "A", If(SortDescending1, Descending, Ascending))

[BaldgytAgain]

Connecting a disconnecting makes no difference. And yes I was adding a gallery

[Drrickryp]

As a test, Please add a new screen and put a DataTable control on a screen and make the Items property Table1 and see if it populates. Also, take a look at this link to see if any of this applies to your table. http://powerappsguide.com/blog/post/how-well-does-powerapps-cope-with-large-excel-files It's other title is Reasons not to use Excel as a data source

[BaldgytAgain]

Columns are available from add fields and column names appear on the control but it says "We didn't find any data at to show at this time"

[Drrickryp]

@BaldgytAgain 

It sounds like there is something wrong with data.  Are any of the columns Calculated?  If so copy the table and paste it in a new sheet using Excel's Paste Special values.  You should be able to recreate calculated columns using PowerApps functions instead.

[BaldgytAgain]

Tried this and had one success - with a file I copied to a different folder (where it failed) but then pasted values (it was only cells with an int(rand()*100) formula for testing and my original spreadsheet that I really wanted to use had no formulae at all anyway.

But this sheet - just integers, no formulae, fails. The columns are connected as you can see in the empty galley and adding a datatable gives the no data to show message. no _poerids_ column appears in the sheet. File on onedrive for business (the only thing I can say that is odd about that drive is that it is currently in the middle of a large [10s of GB] sync).

[eka24]

Just try the table name on the items if you would have data in the Gallery item: Table1

Then try:

SortByColumns(Filter(Search([@Table1], TextSearchBox1.Text, "A","B","C"), "A")

Let me have a feedback

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.