Skip to main content

Pull in related list items using a customized PowerApps list form

PowerApps is a great way to easily customize the new, edit, and/or display forms of list items in SharePoint online. In some cases you may also want to pull in items from another list with items related via a lookup column. In this blog I will discuss the steps to use a gallery control to pull in these related items.

This blog assumes that you have a working knowledge of using PowerApps to customize a list form, if not you can view some information on getting started with PowerApps here: https://powerapps.microsoft.com/ro-ro/blog/microsoft-powerapps-learning-resources/

Starting with a PowerApps customized list form, from the PowerApps canvas select 'Insert' from the ribbon and select one of the Gallery controls. I'll be using Vertical for this demo.


From the Data pane select add data source to connect to the list you would look to pull in data from. Note: This can be any list or library in SharePoint so while lookup columns are site specific if you use something like Flow to relate items via the ID you could also pull in those items via the same method.

The next step is configuring the Items returned in the Gallery, you can do this by selecting the 'Items' property of the control and configuring the filter function as follows:

filter(list,filter criteria)

  • where 'list' is list you would like pull data from
  • where 'criteria' is the name of the column you would like to filter on, in this case it is the id value of a lookup column called projectLookup, equals the id of the current item in the display form. The current item of the display form can be pulled in using 'SharePointIntegration.SelectedListItemID'
    Note: Lookup columns are non-delegable and may not work with larger data sets, to find out more about delegable data sets check out this post: https://blog.mslavieri.com/2019/02/powerapps-delegation-warning.html



The Gallery is now set up to pull in all of the related items in the list from that list. The Gallery control will repeat each of its sections for as many items that are returned. You can customize the Gallery by pulling in different controls or text boxes into one of the repeating sections to customize the Gallery in whatever way you want. If you want to display item properties for the items pulled in you can select 'Fields' in the Gallery pane and select the value you would like for each control. 


This is effectively a UI to update the value in the text property of the control. If you click into a control and select the text property you will see that it has been updated to ThisItem.itemproperty


By knowing this you can use the item's properties to do some unique things such as navigate to the display or edit form of the item like I am doing for the 'Track' button that was added to the Gallery. 


That's it, hopefully you found this guide helpful, if you have any questions ask them in the comments or reach out on twitter @mslavieri

Labels:

Comments

Post a Comment

Popular posts from this blog

SharePoint Site Theming: Header Background Colors

As Microsoft rolls out the new Mega Menu experience for the Modern UI some of you may be wondering where these colors come from. In this post I will review the header background color options and call out which theme colors get used along the way. From left to right in the image below we have the four background options, which I'll call by the names of their color labels, Background Color (White) Theme, Neutral Light Theme, Light Theme, Dark Theme. I used the Microsoft Theme generator ( https://developer.microsoft.com/en-us/fabric#/styles/themegenerator ) to create my theme and applied the theme to my tenant using the Add-PnPTenantTheme ( https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/add-pnptenanttheme?view=sharepoint-ps ) command to apply the following theme in PowerShell, I've also added comments to lines that impact themes for your reference. @{ "themePrimary" = "#0a162b"; #Theme Dark Local "themeLighterAlt" = "...
Post a Comment
Read more

Quick Look at the Surface Duo Android Emulator

Microsoft recently released their SDK and Emulator for developing dual screen applications for the Surface Duo ( https://docs.microsoft.com/en-us/dual-screen/introduction ) and being a bit curious about what the experience was going to be on a dual screen device I decided to give download it and give it a try.  First Impressions First and foremost there is the novelty of having two apps launched side by side. The Duo emulator is using Android Version 10 and to be API version 29, both are the latest versions of Android. There is no Play Store or Microsoft Store on the emulator, which is to be expected as its main purpose is app development. But beyond that it appears that most of the Google applications are not included in the device and the build is based off the Android Open Source Project (AOSP) more than anything else. What typically are the default applications on Android have been replaced with Microsoft Applications.  Launcher is the Microsoft L...
1 comment
Read more

PowerApps Delegation Warning

Update Aug 15 2019 - Microsoft has updated PowerApps to allow for some complex SharePoint data delegation, this will hopefully resolve most issues you were seeing when working with SharePoint data:  https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/ If you've tried to use the Filter, LookUp or Search actions in PowerApps you have seen the yellow warning error that shows a 'delegation warning' and you might have even ignored it because your PowerApp was working fine in testing. However once you get into larger data sets your PowerApp will have some issues so in this blog I will attempt to explain what the delegation warning is and how you can fix your PowerApp. Delegation So what even is Delegation in PowerApps? When doing any sort of data manipulation for an app, PowerApps will try to push the processing of that data to the source system instead of doing all of the manipulation in the app. This is done to increase the efficiency of you...
1 comment
Read more