Using Large Excel files in Power Apps
Using Large Excel files in Power Apps can be problematic due to limitations and potential issues. Excel is not a good place to store Power Apps data, but it is still commonly used. The Excel Connector in Power Apps has limitations, such as a maximum file size of 25MB and a maximum of 64,000 rows when using auto-generated IDs. Delegation issues and limited query filters can also arise. Alternatives to using Excel as a data source include SharePoint lists, Dataverse, and SQL databases. These options provide more stability and flexibility for storing and accessing data in Power Apps.
Article 5w
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time