How To Import Excel to Dataverse using Dataflow
Hey Everyone,
In this video, we'll look at how to import data from an Excel spreadsheet and save it as tables in dataverse. Once the tables are created, we'll create one-to-many relationships and finally use that to create a canvas app.
In my demo, I have a canvas app whose data source was initially in an Excel spreadsheet since I was in the POC stage. Now that I'm ready to move it to production, I need to first import it to Dataverse.
Table of contents
Introduction 0:00
Review the Canvas app 0:47
Create the Dataflow 1:15
Get Data 1:40
Power Query Editor 4:00
Rename Dataflow 8:45
Change the connectors 12:15
Fix the errors 14:08
Conclusion 16:12
Helpful Link(s):
-Introduction To Dataflows in Power Apps: • Introduction to Datafl...
- How To Refresh a Dataflow using Power Automate: • How to Refresh a Dataf...
#PowerApps #Dataflows #Dataverse #ImportExcel
8 июл 2024