Updated: May 21, 2021
Did you know that you can recreate the SharePoint LookUp Column functionality in Power Apps and avoid all the problems? Learn how to recreate this functionality and do even more with Shane’s demo.
In this video you will learn about:
The DropDown control
The SortByColumns function
The LookUp function
Link to the video on YouTube: Power Apps SharePoint LookUp Column
Link to the video for Curated Library subscribers: Recreate SharePoint LookUp Column like functinality - Relationships
1:06 Open Customize forms in Power Apps directly from SharePoint
The Customize forms creates a single screen app with a form. Fields that are not needed are removed from the form.
3:34 Insert a Drop down control in the form and add data from a different SharePoint site collection
In the Edit screen, the Department card is unlocked and the field is deleted. A Drop down control is added to the Department card to create LookUp-like functionality. The data source for the Department card is a SharePoint list from a different site collection. Shane troubleshoots two error messages.
8:14 Set the default value and use the SortByColumns function
The default value is updated to display different departments. The SortByColumns function is added to alphabetize the data in the Department Drop down control.
10:56 Add a new record to the master list using a dash
A new record is added to the master list. The title and manager fields are set to ‘-’ to mimic a blank value. An If function is inserted in the default of the Department Drop down control.
14:53 Open an additional Customize forms in Power Apps directly from SharePoint
A label is inserted in the Department card. The LookUp function is added to display a related column.
18:51 Add a button and use the Launch and Lookup functions
A button is added outside the form. The Launch and LookUp functions are added to open a record form another list.
21:23 Demo of how to hide the label and button if the form mode is new
Shane demonstrates how an If function can be added to either display or hide the label and button depending on the mode of the form.
22:42 Demo of how to switch the custom form back to a default SharePoint form and delete the form
Shane demonstrates how to navigate to list settings and form settings to switch the form back to a default SharePoint form or delete the form entirely.