Excel data in Power Apps Earlier this week I was asked about accessing data in Large Excel files from within Power Apps. Now I’ve never been a fan of Excel as a data source.

Enter Power Apps—a fantastic option that can transform your Excel data into dynamic, interactive applications.

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Automating Power Query Tasks TL;DR Key Takeaways : Integrating VBA with Power Query automates repetitive tasks, optimizes settings, and enhances data workflows in Excel, saving time and resources.