How To Use Lookup Columns In Power Apps

0 Views
Published
How To Use Lookup Columns In Power Apps
Hey Everyone,
In this video I'll walk you through how to use lookup columns in Power Apps. My demo includes SharePoint lists and Dataverse tables. I'll do a side-by-side comparison of the differences and will share some tips and tricks along the way.

Table of contents
Introduction 0:00
Dataverse 0:44
Two existing tables 0:50
Create a new table 4:30
Create a canvas app 6:25
Add the filter formula 13:15
SharePoint 18:55
Two existing lists 19:06
Create a new list 21:10
Update the canvas app 22:30
Add the filter formula 27:26
Conclusion 33:00

Formula for Device Items property:
SharePoint-
Filter(Choices([@'Device Request'].Device), Value in Filter(Device,MFR.Value=varMFR).Name)

Dataverse-
Filter(Choices([@'Device Requests'].cr341_Device),Title in Filter(Devicess, MFR.Title=varMFR).Title)

OnChange for both MFR
Set(varMFR,Self.Selected.Title)

Helpful link(s)
Power Apps: Planning SharePoint Lists Relationships: https://youtu.be/qU22DiaIPpU

#PowerApps #Lookup #SharePoint #Dataverse
Category
Management
Be the first to comment