One of the fundamental pieces of Power Apps are data sources. In this video I explain:

✅ How Power Apps connects to data
✅ The differences between the types of data sources
✅ Guidance on choosing between tabular data sources (Excel, SharePoint, Dataverse, SQL)

🔗 Links 🔗

🔗 Data Source Learn Path: https://aka.ms/april/powerapps-data-sources
🔗 Understanding Delegation: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview?WT.mc_id=power-00000-apdunnam
🔗 Shane Young – Why Excel is a Terrible Data Source: https://youtu.be/RtmZM3tm2Zs
🔗 On Prem Data Gateway: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-reference?WT.mc_id=power-00000-apdunnam

Table of Contents:

00:00 – Intro
00:34 – Accessing Data (Connectors)
02:20 – Data Source Types (Tabular vs Action)
03:20 – Demo: Create an App from Data
05:23 – Action Based Data Sources
06:04 – Demo: Using an Action Based Data Source
08:35 – Comparing Tabular Data Sources
11:26 – SharePoint
13:55 – Dataverse for Teams
15:24 – Demo: Dataverse for Teams Use Cases
15:58 – Azure SQL and Dataverse
18:31 – Wrap Up

Previous articleMicrosoft Teams: recent updates
Next articlePower Apps working with SharePoint List Relationships
avatar
I'm a Partner Technical Architect at Microsoft and Power Apps/Power Automate MVP Alumni. As a Partner Technical Architect on the Modern Workplace Team, I focus on helping our partner ecosystem skill-up on Teams and Power Platform and overcome technical barriers. I'm a developer who is passionate about the Power Platform. I have an active YouTube Channel and blog where I share how-to videos and demos around Power Apps, Power Automate, Teams and SharePoint. I regularly speak at events across the globe to share Power Platform knowledge. On top of blogging, I speak at local tech events and run the local PowerApps and Flow User Group. When I’m not working I love going to karaoke or trivia night at the local brewery.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.