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
Solved! Go to Solution.
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
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
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?
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
@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')