Skip to main content

Notifications

Community site session details

Community site session details

Session Id : AfknX+5B0Cw8f5wPDpa+1E

How to use lookup columns in Power Apps

darogael Profile Picture Posted 10 Jan 2022 by darogael 123 Most Valuable Professional

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