How To Use Lookup Columns In Power Apps

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)

#PowerApps #Lookup #SharePoint #Dataverse

[alain]

Thanks so much. I just discovered Power App and now I can see the power of it.

[kevindibb]

@14:00 - everything you did here just made me happy because it's exactly how I type, shift/end to select the row, of course CTRL C, shift/enter; but people who don't type like this just do not understand how much easier it is when you learn basic keyboard commands. Seems like most people are at least familiar with CTRL C/X/V/Y but beyond that not much more.

[AndrewSmith-zmvn]

Another great video to help me in my journey of discovering and learning about Powerapps.

[abbasthegreat]

Thanks Daniel, You made my day.
GOD bless you.

[luizzers]

Thank you very much this is what I was looking for. Thanks thanks thanks

[designmycity]

AWesome video. Thank you very much for this great video.

[fzawadi]

Great video. i liked the WOW factor in dataverse 🙂

[cindyduncan]

Thank you for the GREAT video!
Could we get a "deep dive" into "Allow multiple values" and submitting the form into a SharePoint list? =)

[arulmanohar]

How to use lookup concept in dataverse? Can we autopopulate /fetch a column's value based on another column value of that record in dataverse without using any flow?

[calummclean]

this has been super helpful, would I be correct on saying that the extended field cannot be used in gallery sorting etc. as they are complex types? Is there an alternative approach to accomplish this? Thanks

[skawathe]

Why did filtering for SharePoint lookup column not show delegation warning even though warning was shown for Dataverse?

[krishnamurthyelumalai]

How to store SP lookup field values into collection instead of record?