cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

@HVL,

 

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

Snipaste_2019-12-11_14-10-18.pngSnipaste_2019-12-11_14-09-40.png

Best regards,

Sik

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

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

@HVL,

 

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

Snipaste_2019-12-11_14-10-18.pngSnipaste_2019-12-11_14-09-40.png

Best regards,

Sik

View solution in original post

Highlighted
Helper III
Helper III

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

@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. 

Highlighted
Helper III
Helper III

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

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

Highlighted
Helper III
Helper III

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

@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

Highlighted
Community Support
Community Support

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

@HVL 

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,774)