Answered

Lookup Person columns from another SharePoint List

(0) Share

Report

Posted on by RodM

193

I have 2 SharePoint lists with the same 3 Person fields (Employee, Supervisor, Manager), and I'd like to use one of the lists as a lookup based on the "Employee" selected.

Ex: User finds and selects the Employee from the people picker, and the other people pickers will auto-populate based on the related Supervisor and Manager in the new item form created by a formula in Default.

I tried my best to follow this blog post but could not comprehend the points they were making:
Defining default values for complex SharePoint types in forms | Microsoft Power Apps

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @RodM ,

You cannot use a Person (or any other complex type) field in another list for a Lookup in SharePoint. I actually never use Lookup fields in SharePoint as you can do the Lookup in Power Apps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RodM 193 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I'm not trying to do the lookup in SharePoint, I'm trying to do the lookup in my PowerApp.

How am I able to lookup items on another list, by referencing a Person column within PowerApps?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @RodM ,

Can you please share (in Text) the code you have attempted. You would need something like (I am guessing the control output here)

LookUp( YourSPList, YourPersonField.DisplayName = YourDropDown.Selected.DisplayName )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RodM 193 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz ,
Thank you!, I was able to figure it out, this is what worked:
LookUp('QA Scoring List',DataCardValue129.Selected.DisplayName = Employee.DisplayName,'Assigned Supervisor')

Was this reply helpful? Yes No