Answered

Generating PowerAppId for Excel Table for Data Added via Excel

(0) Share

Report

Posted on by Aylanna

I have built a power app with quite a few pages, based off, in part, an Excel file, that has many fields.

The data changes/updates on a monthly basis. The number of rows fluctuate, with anywhere between 1000-1500 rows. There are almost 20 columns. This data is NOT manageable in a SharePoint list; the data is originally from an external database, which cannot be directly connect to the PowerApp. It is unacceptable to have someone go line by line, data point by data point, to review for changes. As such, the data from the database must be exported to an Excel file, formatted, and then copied and pasted in to the Excel file connect to the app.

It is also not feasible to have to rebuild the app EVERY SINGLE TIME that the data has to be refreshed/updated.

From what I can uncover in other posts, if data is added to the source file via Excel, PowerApps will not generate the row a PowerAppsId automatically.

How can I get it to generate a PowerAppsId so I'm not in a continual state of having to rebuild the thing????????

Frankly, if I can't get a PowerAppsId to generate, then I essentially have to scrap it, and we really need this app/capability.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Aylanna

If you connect to an Excel data source using the Excel Online Business connector, you can use the drop down to select the unique column in your Excel data. By doing this, Power Apps won't create the PowerAppsId column and there won't be any dependency on this column.

Was this reply helpful? Yes No
Aylanna 29 on at

Like
a
(0)

Report
Copy link

Link copied!

I just tried deleting and re-adding the data sources using this method, but it's still not pulling all of the values. If I do a particular set of filters, I should have 38 options in the ItemList, but I have about 18. I've even refreshed the data.

I will definitely use a unique field moving forward, because the dependency is obviously not good.

Any thoughts, other than rebuilding, for how I can get it to pull the full listing?

Was this reply helpful? Yes No
timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aylanna - how many records are in your Excel spreadsheet and what filter operators are you using? This could very well be a delegation issue.

Was this reply helpful? Yes No
Aylanna 29 on at

Like
a
(0)

Report
Copy link

Link copied!

968 In this last data drop. I'm an owner of the Team where the storage folder is, as well as the owner of the app.

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If you go to the Settings of your app, in General, is the 'data row limit' set to maximum value of 2000?

Was this reply helpful? Yes No
Aylanna 29 on at

Like
a
(0)

Report
Copy link

Link copied!

It was not ... now that it is, all fixed!! Thank you so much!!

Was this reply helpful? Yes No