cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Cascading Dropdown auto-populate people names ComboBox from SharePoint list

Hello,

 

I am creating SharePoint form which is linked to other list with Countries and Units. Each unit is assigned to Attention A/P contacts and it can be more than one person, therefore this field is a ComboBox.

 

I created cascading dropdowns for Units and Entities and these are working for single dropdown, however not for my ComboBox. It is not populating people names from my second list.

Combo1.JPG

 

My list from which I need to source the data looks like this:

Combo2.JPG

 

 

Do you have any ideas how to make this work?

 

I appreciate any hints!

Many thanks!

 

Cheers

Iweta

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous ,

 

So, you want the 3 person to be selected in default, right?

If so, please try this:

1. set SelectMultiple property to true

2. apply that formula to DefaultSelectedItems property:

LookUp('HFM Mapping', 'HFM Code'='HFMCode_TBC.Selected.Value).'Attention A/P'

Hope this helps.

Sik

View solution in original post

4 REPLIES 4
v-siky-msft
Community Support
Community Support

Hi @Anonymous ,

 

Do you mean you want to set the items of 'Attention A/P' based on the HFM code Dropdown selection?

Please try this:

LookUp('HFM Mapping', 'HFM Code'='HFMCode_TBC.Selected.Value).'Attention A/P'

Hope this helps.

Sik

 

Anonymous
Not applicable

Hi Sik,

 

Thanks for that, it's almost what I needed. When I applied formula you proposed,  dropdown feeds with people names but I can pick only one of them. I need this to be feeded with all the names it finds for particular HFMCode. So if on list HFM Mapping I've got 3 names, all 3 should appear in my ComboBox, not one under another but all 3 at once. Is it possible?

 

Thanks a lot!

 

Cheers

Iweta

Hi @Anonymous ,

 

So, you want the 3 person to be selected in default, right?

If so, please try this:

1. set SelectMultiple property to true

2. apply that formula to DefaultSelectedItems property:

LookUp('HFM Mapping', 'HFM Code'='HFMCode_TBC.Selected.Value).'Attention A/P'

Hope this helps.

Sik

Anonymous
Not applicable

Thanks a lot Sik! This is exactly what I've been looking for!

Cheers

Iweta

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,575)