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.
My list from which I need to source the data looks like this:
Do you have any ideas how to make this work?
I appreciate any hints!
Many thanks!
Cheers
Iweta
Solved! Go to Solution.
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
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
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
Thanks a lot Sik! This is exactly what I've been looking for!
Cheers
Iweta
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
71 | |
50 | |
43 | |
30 |
User | Count |
---|---|
259 | |
124 | |
87 | |
85 | |
82 |