Existing Data in Excel not Populating App

[PTurner_CPE]

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!

[PowerAddict]

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)

[PTurner_CPE]

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!

[PowerAddict]

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]

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

[PTurner_CPE]

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?

[PowerAddict]

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)