You’re offline. This is a read only version of the page.
I'm trying to build an app that tracks coaches and coachees. New and recently promoted employees are assigned a coach. I have two lists, one has the list of trained coaches and the other has the employees that need a coach. Both lists are connected to a Power app for the supervisors to manage. I would like for the Coachee list to be able to populate a dropdown with the list of coach's names to choose from. I originally used a lookup column on the SharePoint list but everything I'm reading is saying I should not use a Lookup column on the SharePoint list and use Lookup in the Power App instead. I can't figure out how to make the field into a lookup field in the PowerApp. Help! Bonus points if you can tell me how to filter out those coaches that already have 3 coachees. TIA
HI @IBrant,
Yes, then notice the way you set the Items property of the combobox and update the LookUp columns.
HI @IBrant,
Using LookUp column is not that complicated...
So in coachees list, you have LookUp columns to select coach from coach list, right?
If so, you just need a ComboBox, and populate the Items proeprty with Choices(list_coachees.Coach), and then refer to ComboBox.Selected when you do update thing.
Since you have another LookUp column for coach email, there is no need to use a Person column for all the employees involved.
Hi
Correct - Keep SharePoint simple and let Power Apps do the work so no lookup columns in SharePoint.
Can you paste the list settings for each list? (There should be nothing confidential because it simply displays the configuration for each column) e.g.
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (
