Answered

Template app assist

(0) Share

Report

Posted on by russrimm Microsoft Employee

Hi all, I'm trying to learn using the "Asset Checkout" template app. It pulls from an Excel spreadsheet on onedrive.

When I add new rows to the Excel, i'm having trouble with it not displaying them. What do I do about the __PowerAppsID__ column? I realize it creates it when you connect the app to an Excel datasource, but when you want to manually update the table by adding new rows, do you just leave that column blank? Or when using an existing Excel worksheet as a datasource is it only possible to add new rows via the PowerApp or Flow but not manually? I'm suspecting I should change my datasource to SQL or a Sharepoint list?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WillPage 2,307 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You probabaly need to add Refresh('Table_Whatever') to the OnVisible property of the screen, and also maybe have a refresh button with the same as the OnSelect. You might also consider adding a timer on repeat with the OnTimerEnd property as such too, should you want to automatically referesh the data source every 30 seconds or whatever.

Was this reply helpful? Yes No
Verified answer

russrimm Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks, I ended up realizing it was more of a OneDrive sync issue causing my data to not update. I also noticed it's not too hard to temporarily break the app if you have the Excel spreadsheet open.

Was this reply helpful? Yes No
WillPage 2,307 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Yup. You'll outgrow an Excel table as a data source pretty quickly developing PowerApps. Handy for very basic data sets and rarely used/single user apps, but that's about it.

Was this reply helpful? Yes No