Create Power Apps from Excel with data | Microsoft AI Copilot
37.3 هزار بار بازدید -
پارسال
-
In this video, I will
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.
When you upload an Excel file it generates a Dataverse table.
Why use Dataverse?
https://learn.microsoft.com/en-us/pow...
Create a canvas app with data from an Excel file
https://learn.microsoft.com/en-us/pow...
#PowerApps #Excel #Dataverse #copilot #microsoft
Table of Contents:
00:00 - Get started with converting Excel files with data into Power Apps
00:51 - Create your first App with data from an Excel file with Microsoft AI Copilot
07:16 - Create Power Apps from Excel file with data
08:14 - Challenges with creating Power Apps from Excel
09:56 - Build a Power App with data from Excel transformed using Power Query into Dataverse
18:35 - Subscribe to Reza Dorrani Channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: LinkedIn: rezadorrani
🐦 Reza Dorrani Twitter: Twitter: rezadorrani
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.
When you upload an Excel file it generates a Dataverse table.
Why use Dataverse?
https://learn.microsoft.com/en-us/pow...
Create a canvas app with data from an Excel file
https://learn.microsoft.com/en-us/pow...
#PowerApps #Excel #Dataverse #copilot #microsoft
Table of Contents:
00:00 - Get started with converting Excel files with data into Power Apps
00:51 - Create your first App with data from an Excel file with Microsoft AI Copilot
07:16 - Create Power Apps from Excel file with data
08:14 - Challenges with creating Power Apps from Excel
09:56 - Build a Power App with data from Excel transformed using Power Query into Dataverse
18:35 - Subscribe to Reza Dorrani Channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: LinkedIn: rezadorrani
🐦 Reza Dorrani Twitter: Twitter: rezadorrani
پارسال
در تاریخ 1402/03/09 منتشر شده
است.
37,382
بـار بازدید شده