Skip to main content

Notifications

How to use lookup columns in Power Apps

darogael Profile Picture Posted by darogael 123

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)

Categories:

Canvas Apps Dataverse General PowerApps

Comments

*This post is locked for comments