Answered

Lookup Choice Column

(0) Share

Report

Posted on by IBrant

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
IBrant on at

Like (0)

Report

Currently, they look like this. I would love to use people picker columns for all the employees involved but from what I understand that would complicate things.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

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.

Was this reply helpful? Yes No
IBrant on at

Like (0)

Report

Okay, so I should just keep those columns as lookup columns in my SharePoint list?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

HI @IBrant,

Yes, then notice the way you set the Items property of the combobox and update the LookUp columns.

Was this reply helpful? Yes No