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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 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 (3,255)