Answered

OneDrive Excel Connection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm using Excel files on my OneDrive as a data source for my app.

Everything was working perfectly until today. I added a new table as a data source and nothing was showing (when displaying the data source it just shows "We didn't find any data") . When I checked the file, the _PowerAppsID_ column wasn't generated.

The data is formatted as a table and I dont have the file open while working on Power Apps. I just can't figure out what's wrong here.

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I suggest you remove the Table connection in Powerapps and reconnect again until the Id is generated.

------------

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Tried that multiple times and nothing; it always gives me the "we didn't find any data" message
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

So the PowerApps_id is still not created?
------------

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It's not. I checked the file after every time and there's still no PowerAppsId column
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What about recreating the Table itself again. So if table1 delete it in excel and recreate it
------------

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Did that as well. Recreated the table in a different sheet, different workbook. Nothing seems to work
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Kindly show the current excel table.
------------

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.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Finally got it to work! I believe the problem was caused by the last column in the table being empty (end user was supposed to enter data here). I just entered dummy data in that column and everything showed up.

Thanks
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

That's fine. Mark the solution to close the post
------------

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.