cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
satishkumark
Helper I
Helper I

cascading dropdown for people picker column

Hi, 

I have 2 SharePoint lists 1.Direct Benefit 2. Direct Benefit WL3 Team

Now I need to select a entity based on that need to display a Work Level 3 (ComboBox People Picker values ).

let suppose, if I select entity a Bengaluru , need to display work level 3 values which are there in List2 of column(WL3Members) 

 

List1:

satishkumark_0-1631721883652.png

list2:

satishkumark_1-1631722020002.png

Please help me out how to achieve this scenario.

Thanks 

Satish

 

 

5 REPLIES 5
zmansuri
Super User
Super User

a8.jpga9.jpga10.jpga11.jpg

satishkumark
Helper I
Helper I

Thanks Mansuri for quick response.

I used the same formula in Items property of work Level 3 ComboBox, but getting a error message-Expected a Table Value.

satishkumark_0-1631728474304.png

Thanks

 

Hi @satishkumark ,

 

The two People columns both allow multiple selections, am I right?

 

If so, you will need to use Choices('Direct Benefit WL3 Team'.WL3Members) as Items of the 'Work Level 3' Combobox, and set DefaultSelectedItems of it to:

LookUp('Direct Benefit WL3 Team', Entity = EntityCombobox.Selected.Value).'WL3Members'

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Hi  Jeffer Ni,

Thanks for the response,

As you mentioned, I used the same code, but getting Incompatible types of comparison: these types can't be compared: Record, Text 

satishkumark_1-1632377268533.png

satishkumark_0-1632377189878.png

Thanks for the help.

Hi @satishkumark ,

 

If Entity column is not Text type then:

LookUp('Direct Benefit WL3 Team', Entity.Value = EntityCombobox.Selected.Value).WL3Members

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,536)