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.
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)