cascading dropdown for people picker column

(0) Share

Report

Posted on by satishkumark

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:

list2:

Please help me out how to achieve this scenario.

Thanks

Satish

All responses (6)

Answers (0)

AkshayManke on at

Like (0)

Report

Re: cascading dropdown for people picker column

Great Tip @zmansuri, Many thanks for sharing the information.
v-jefferni on at

Like (0)

Report
Re: cascading dropdown for people picker column

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.
satishkumark 43 on at

Like (0)

Report

Re: cascading dropdown for people picker column

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
Thanks for the help.
v-jefferni on at

Like (1)

Report
Re: cascading dropdown for people picker column

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.
satishkumark 43 on at

Like (0)

Report

Re: cascading dropdown for people picker column

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.
Thanks
zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report

Re: cascading dropdown for people picker column