Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Import from Excel

I'm having to use manual Excel imports for a datasource due to the row limitations of Connected options. The data compiled into those imports is fluid and requires update every one to three days. Is there a manner in which I can automate the import? Perhaps a Powershell script?


In case it's of any consequence, the total rows ClearCollected into my Collection OnStart are derived from two Excel tables totaling ~20K rows which I separate out; 15K to the first, the remainder to the second.

Power Apps
Power Apps

If I understand correctly, you have been importing static data into your app as an alternative to using connected data. This is your work around to avoid delegation issues.


Given that your use case is one where data is not static (you need to regularly update it), your work around may not fit what you're trying to achieve.


As a guiding principle, when you are building your app, work towards lightweight, minimal experiences. At first, you may want to bring in all of your data, but how much of it is actually seen and acted upon at any given time? How much of it is actually needed at once? Are your current data source options adequate or are you in need of something more robust?


The more you step away from trying to recreate spreadsheet experiences in PowerApps, the better app experience you'll be able to deliver.

Hey Mr. Dang!

The intent driving my app is simplicity, and this awesome platform has allowed me to place a cumbersome amount of data into a very simple and very fast, in fact rediculously fast, tool that supports users of our NAV environment. Unfortunately, for the app to perform it's duty it must first make available for search all of the items because all of those items are both unique to one another and also likely to be searched for at any given time. So basically, the app serves its function extremely well and so for that I have no concern. It does exactly what you say it should; lightens and minimalizes our data so that we can have the information we need without the drudgery of spreadsheets or having to fire up NAV.


So anyway, about this particular ask, yes I am being lazy 👍

But can you think of a way that might automate my updates to the Datasource?

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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