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.
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?
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.