Answered

Template app assist

Like (0) Share

Report

Posted on 7 Apr 2019 16:01:34 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:

General Questions

All responses (3)

Answers (1)

WillPage 1,907 on 07 Apr 2019 at 22:38:24

Like (1)

Report

Re: Template app assist

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

russrimm Microsoft Employee on 07 Apr 2019 at 22:33:48

Like (1)

Report

Re: Template app assist

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.
WillPage 1,907 on 07 Apr 2019 at 22:06:18

Like (1)

Report

Re: Template app assist

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.