cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PTurner_CPE
Regular Visitor

Existing Data in Excel not Populating App

I've created a small app from an existing excel file. The data was already in the spreadsheet and I then converted it into a table and named the table. The App when created pulled all of the correct headers, it adds, edits, and deletes, information, but only new information done through the app, and it will not pull any of the pre-existing information into the app to view, edit, search etc. Did I create the table incorrectly? Did I miss an import setting to include existing data and not just new data? Thanks!

6 REPLIES 6
PowerAddict
Super User
Super User

Did you create the data after you connected your excel as a data source to the app? If so, can you remove the excel as a data source from the app and add it back?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Thanks for the quick reply.  A portion of the data was created after the connection. The portion after shows up. The portion created before the table was made and the connection was made does not show up.

 

Also, sorry I'm not sure how to remove and then reconnect the data.

 

Thanks again for the help!

Click on the datasource on the left side navigation, click on the 3 dots next to it, and click on Remove. And then add the datasource back. Let me know if this helps. (screenshot attached)

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

v-siky-msft
Community Support
Community Support

Hi @PTurner_CPE ,

 

I have made a test, and don't have the issue you mentioned.

Although I find out the reason, I believe that is a rare event. you can go to check if there is any value in PowerApps_ID column of your table, if there is , that means your table records is recognized by PowerApps. Otherwise, could you try to delete it and re-create one?

For more reference: Format a table in Excel and naming tips 

 

Best regards,

Sik

Thanks for both suggestions.

 

1) I've removed and re-added the data link and the result is the same, in fact now it doesn't show the previous entries done through the app.

2) each row in the app is assigned a PowerAppID but still doesn't get pulled into the app

3) for some reason I'm also getting an error that PowerApp does not support excel files with a function in them?

Can you share a sample excel file that you are using? Doesn't have to have real data or real column names, but getting the layout will be helpful in trying to replicate the experience. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,312)