Day 20: Importing and Exporting Data
In today's video we'll learn simple methods of importing and exporting data. We'll be looking at not only the Maker methods, but also the end-user or Model Driven app consumer methods for exporting to a CSV. We'll also do a demo of how you can import a table from SharePoint into Dataverse very easily - but this method can be used for any of the data sources available in Power Query.
Note: Tomorrow we'll explore this topic even further as we will discuss the recommended service for migrations and synchronizations which is Dataflow.
Recommended reading and watching:
Data Import and Export:
https://learn.microsoft.com/power-app...
Using File Templates:
https://learn.microsoft.com/power-app...
BONUS VIDEO 1: Power CAT Live video on Alternate Keys with Yasin Alladin Mukadam:
• Easier Imports With Dataverse Alterna...
BONUS VIDEO 2: Data Migration Utility by Brian Knight of Pragmatic Works:
• Migrate Dataverse Data Between Enviro...
Previous Videos:
0. Introduction Video: • INTRO - The Dataverse Advent Calendar...
1. Day 1: Let's take a tour: • Dataverse Advent Calendar Day 1: Let'...
2. Day 2: New app format! • Dataverse Advent Calendar Day 2: A ne...
3. Day 3: Solutions: • Dataverse Advent Calendar Day 3: Solu...
4. Day 4: The Innovation Backlog solution by the Power CAT team: • Dataverse Advent Calendar Day 4: The ...
5. Day 5: Tables (built-in and context): • Dataverse Advent Calendar Day 5: Tables
6. Day 6: Let's make a table: • Dataverse Advent Calendar Day 6: Let'...
7. Day 7: Special Column Types: • Dataverse Advent Calendar Day 7: Spec...
8. Day 8: Table Relationships: • Dataverse Advent Calendar Day 8: Tabl...
9. Day 9: Table Views: • Dataverse Advent Calendar Day 9: Tab...
10. Day 10: Forms (Model Driven): • Dataverse Advent Calendar Day 10: Fo...
11. Day 11: Building Model Driven Apps: • Dataverse Advent Calendar Day 11: Bu...
12. Day 12: Intro to Building Custom Pages: • Dataverse Advent Calendar Day 12: In...
13. Day 13: Intro to Building Canvas Apps (Rasika): • Dataverse Advent Calendar Day 13: Bui...
14. Day 14: Improve Canvas App Designs with the Creator Kit: • Day 14: Improve Canvas App Designs wi...
15. Day 15: Easy as Pie Power BI Integrations:
• Dataverse Advent Calendar Day 15: Eas...
16. Day 16: The purpose of Business Rules: • Dataverse Advent Calendar Day 16: The...
17. Day 17: Understanding the Value of Business Process Flows (BPF): • Day 17: Understanding the Value of B...
18. Calling Dataverse from Power Automate: • Dataverse Advent Calendar Day 18: Cal...
19. Helpful Tips for Power Automate & Power Virtual Agents flows: • Day 19: Helpful Tips for Power Automa...
Additional assets for this series will be kept here in the Power Apps community:
https://powerusers.microsoft.com/t5/W...
Enjoy,
Audrie