Power Apps Data Sources Explained

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

April Dunnamhttps://www.sharepointsiren.com/
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.

Related Articles

Leave a Reply

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

Stay Connected


Subscribe to our newsletter

To be updated with all the latest news, offers and special announcements.

Latest Articles