Cascading dropdowns to return specific person or group based on a dependant

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

This question has probably been asked several times but I can't seem to find an answer that directly resolves my issue.

I have created several SP lists, each holding specific data

List 1 - list of divisions

List 2 - list of cost centres and responsible managers (this is a person or group column) and lookup to the division SP list.

List 3 - this is the list the powerapps form is created from and contains all the above including additional columns of information.

I have produced several cascading dropdowns

Dropdown 1 - user chooses division

Dropdown 2 - filtered to show cost centres within the chosen division. User chooses appropriate cost centre

I would like to have a third dropdown that displays the specific manager's email who is responsible for the chosen cost centre, which can then be used to fire off an email.

Any ideas how i can achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous,

I have made a test from my side, please refer to the following steps.
1. add three combo boxes
2. set combobox1's Items property:
Choices('list 2'. LookUpColumn)
3. set combobox2's Items property:
Filter('List 2',LookUpColumn.Value=ComboBox1.Selected.Value)
4. set combobox3's Items property:
LookUp('List2',ID=ComboBox2.Selected.ID).Managers
Best regards,
Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft thanks for this. Woudl this also work if I use a dropdown box rather than a Combo box? I can't seem to get it to work on my side.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft sorry, i take that back. It works! Thank you!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft just to complicate matters a little, in the 3rd combo box, would it work if i asked it to lookup 2 columns and present me with the options? For example, i have a 'manager' column as well as a 'next level manager' column and I want the combo box to return both for the user to choose.

Many Thanks

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
If you want 'next level manager' column show in the third combo box too, I don't think it can be possible.
Best regards,
Sik

Was this reply helpful? Yes No