In this video, I will demonstrate how to create your first canvas app in Power Apps using data from Excel. You'll select an Excel file, create an app, and then run the app that you create. By generating an app, you can quickly get a working app using Excel data be it coming from Excel sheet or tables, and then you can customize the Power App to better suit your needs.
Also, the Microsoft AI Copilot feature can assist in Dataverse table creation by suggesting table names, descriptions, column data types, and headers, even if this information is missing from the uploaded Excel file. When Copilot AI is used for table creation, the Copilot card is displayed to indicate that the table was generated by Copilot AI.
I will also cover the gotchas related to this feature and how we can work with complex excel files (multiple sheets, tables etc.), use Power Query to completely transform the data from Excel, load data into an existing or new Dataverse Table and build our own Power App.
Regards,
Reza
