Mastering SharePoint List Relationships in Power Apps | Create Responsive Repeating Tables
In this step-by-step tutorial video, we will learn how to build related SharePoint Lists using Lookup columns and work seamlessly with multiple related lists within Power Apps.
🚀 What You’ll Learn 🚀
🔹 Power Apps working with List Relationships
🔹 Establishing a 1:N relationship between projects and tasks in SharePoint/Microsoft Lists.
🔹 Creating a fully responsive Canvas Power App connected to your Main List.
🔹 Leveraging Power Apps Galleries to craft an Editable Grid experience similar to InfoPath Repeating Tables.
🔹 Performing CRUD (Create, Read, Update, Delete) operations effortlessly.
🔹 Saving Grid Updates to your data source with a single, efficient Patch function.
🔹 Sorting grid data
🔹 Horizontal scroll for Vertical Gallery in Power Apps
🔹 Sticky Header for Grid/Gallery/Repeating Table
🔹 and much more!
If you’re looking to enhance your skills and create Excel-like Grid experiences with multiple related SharePoint Lists in Power Apps, this tutorial has you covered.
⬇️ Download sample Power App shown in video:
Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
Find the download link in the Community Tab for Members.
To become a member, click here: https://www.youtube.com/rezadorrani/join
Power Apps Editable Grid / Table playlist:
https://www.youtube.com/playlist?list=PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU
#PowerApps #SharePoint #PowerPlatform
Table of Contents:
00:00 – Introduction to working with SharePoint List Relationships in PowerApps
00:49 – Demo of Power App connected to multiple related SharePoint Lists
02:59 – Connect SharePoint Lists using Lookup column
06:42 – Build a Responsive Canvas Power App connected to SharePoint List
08:02 – Editable Grid experience using Gallery in Power Apps
20:43 – Add a new row to Grid
23:26 – Power Apps Gallery as an editable grid
24:10 – Set Grid Menu buttons
25:36 – Power Apps Grid show latest data from related SharePoint list
26:26 – Horizontal scrollbar for a Power App Vertical Gallery
29:24 – Sort Gallery/Repeating Table/Grid
29:50 – Delete row from Power Apps Gallery
30:44 – Sticky header with horizontal scroll for Power Apps
32:29 – Subscribe to Reza Dorrani Channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: https://www.linkedin.com/in/rezadorrani/
🐦 Reza Dorrani Twitter: https://twitter.com/rezadorrani
Comments are closed.