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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report

Was this reply helpful? Yes No
satishkumark 43 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
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.

Was this reply helpful? Yes No
satishkumark 43 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
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.

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (0)

Report

Great Tip @zmansuri, Many thanks for sharing the information.

Was this reply helpful? Yes No