In this stepbystep 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 Excellike 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:
• Power Apps Grid
#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: / rezadorrani
Reza Dorrani Twitter: / rezadorrani