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:
https://youtu.be/POrYpaoNjBM
- How To Refresh a Dataflow using Power Automate:
https://youtu.be/orA14T5iFEE
#PowerApps #Dataflows #Dataverse #ImportExcel