Recreate the SharePoint LookUp Column functionality in Power Apps

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

Key timestamps:

  • 0:00 Intro

  • 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