cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
optoluctor
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.

2 REPLIES 2
Power Apps
Power Apps

Re: Import from Excel

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.

optoluctor
Frequent Visitor

Re: Import from Excel

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

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,915)