To load Excel as static data, go to View > Datasources, search for Excel and select the Import from Excel option.
hi @timl that is understood, but is it possible to store the data within powerapps .. I do want the data to load from the excel the next time app is launched.
When we add static data, that data is stored within PowerApps. There's no need to reload it when the app loads on subsequent occasions.
The limitation is that users can't add records to static Excel that you've imported. Is that what you want to do?
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020