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?

[BaldgytAgain]

No data, no errors. I think it is the connection creationthat is failing as there is no powerapsid in the table.

[BaldgytAgain]

OK
I tried copying the test sheet to another office 365 account (luckily I have 5). Works fine there.

But trying my original sheet still fails in both environments.

Is there any element of powerapps which is locally installed on my machine? I did have the old desktop app installed at one point.

[eka24]

I guess you imported it instead of creating a connection?

The main issue is no app id:
https://youtu.be/zADj0k0waFY

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]

no - it's a connection

[BaldgytAgain]

Here's an example of a sheet that won't work in my environment - the creat app wizards also fail using one drive for business connector.

[eka24]

The attached is no properly formatted excel table. it wont work. follow the video I sent earlier

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]

Thanks 

@eka24 not sure what you mean by properly formated - I formatted as a table.

Unfortunately, your video link just gives me a Grammarly ad (and then other ads - I watched to the end in case yours followed).

Here's another file that fails - it is extremely simple and would seem to have a normal table only.

[eka24]

Try these:
https://youtu.be/-Z_13J02RPU?t=207

https://youtu.be/zL1H-d2xx80?t=4

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]

@eka24 Sorry both these videos are beginners step by step guides on how to connect an excel sheet with a table to an app. I have done that loads of times and haven't had problems until recently.

Did you mean to post videos about missing app ids that you mentioned above in your "explanation"?

Also, the sheets attached you have normal tables created by format as a table and insert table. What did you mean by properly formatted?

Just to be clear, the table appears to connect through the one drive connector, the fields appear, but there is no data and no _powerppasId_ column appears in the table.

Attached is an image of table1's definition in my testsheet. This a very simple sheet with a table with columns called A,b ,C and jsut random integers (no formulae) and it has the same problem.
Existing apps I have made with similar tables continue to work - I just can't create new ones using new sheets.

[eka24]

"Just to be clear, the table appears to connect through the one drive connector, the fields appear, but there is no data and no _powerppasId_ column appears in the table."

Do you know why your table does not have no _powerppasId_?