Building a Scalable PowerApp: A Deep Dive into SharePoint & Dataverse Data Structures

In this video, we take a deep dive into the data structure behind our Capital Expenditure (CapEx) PowerApp. I’ll walk you through how we’ve set up our SharePoint lists and libraries for requests, line items, approvals, and attachments. While we're using SharePoint for this app, the same principles apply if you use Dataverse—making your app scalable, efficient, and easy to maintain.

🔍 What You’ll Learn:
✅ How SharePoint lists and libraries structure the CapEx app
✅ The relationship between requests, line items, approvals, and attachments
✅ Why libraries work better than lists for file uploads
✅ Best practices for scalable PowerApps data models

💡 Next Up: Stay tuned for the next video, where we’ll break down how Power Automate handles approvals in the CapEx app.

💬 I want to hear from you! What PowerApps features or business challenges are you tackling? Let me know in the comments, and your suggestion could inspire my next video!

🛠️ Helpful Resources:
CapEx App Series Playlist - https://www.youtube.com/playlist?list=PL8RhHAHQqJqWnRKEAk_zb3r-8ZSgKwz8S
Why Use Document Libraries, NOT Lists - https://youtu.be/l3hpTjhAgzw

🎬 Table of Contents
00:00 Intro
01:05 CapEx Overview
02:24 Main CapEx List
02:31 Adding a Data Source
04:23 One Source of Truth
04:56 Using a ComboBox from a List for Text
06:17 List for Individual Line Items One to Many
07:10 Using the List GUI to Move Columns
07:40 Tying Records Together with MasterID
09:10 Attachment Library
09:56 Why you SHOULD use Libraries for Docs
10:35 Approvals List

😻 Want to download the Power App from this video?
➡️ Head over to the Community Tab—it's available exclusively for Channel Members!
Not a member yet? No worries! Click here to join and get access: https://www.youtube.com/@StephMarshall/join

🎈 Connect with me!
https://www.linkedin.com/in/stephanie-marshall-95b1b82b/

☕ Buy Me a Coffee - https://www.buymeacoffee.com/stephDR