web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup Link from Share...

Power Apps

Answered

Lookup Link from SharePoint

(0) Share

Report

Report

Posted on by Alex-W

331

Is it possible to have a lookup field from SharePoint with the link in a Power App? I can add the lookup field to the app, but the link is removed. I have only found one similar question online and the person that responded suggested using the Launch() function with the data card which does not make sense and it does not work.

So, is this lookup link in Power App a limitation or is there a way to make this work?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Alex-W ,

The lookup column value is just a record {Id:***,Value:***} in PowerApps.

If you want to display related records by clicking on a record in List A, please try it:

Add a gallery and set its items to- List A

Set the gallery's OnSelect property to:

Set var(ThisItem.<your lookup column name>.Id)

Add another gallery and set its items to -

Filter(ListB,ID=var)

// List A has a lookup column, and its related list is list B.

Best Regards,

Wearsky
Alex-W 331 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft Amazing.... Simply AMAZING!!! It doesn't quite work like what I was expecting but it does work. I can design the app around this setup. Thanks for the help!!

FYI to anyone following Wearsky's instructions, there is a slight modification to the setup for List A. The OnSelect property is "Set (varVarName, ThisItem.LookupColumnName.Id).

Join the conversation