Cascading drop-down for "Person field in SharePoint list".

(0) Share

Report

Posted on by DhivyaSL

Hi,

I'm trying to create a cascading drop-down.

I have created two columns in SharePoint. Division (choice type) and PM_details (contains names of the PM and used person field type). Based on the division selection PM_details (names) has to be displayed.

Sharepoint List

PowerApp Form.jpg

I have included the screenshot of my form and list. As the PM_details column is in person field type, I'm unable to fetch that column details in my PowerApps form. kindly guide me with this.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @DhivyaSL ,

Please try below formula for Items of the second Dropdown:

Distinct( Filter(SPList, Division.Value = Combobox1.Selected.Value).PM_details, PM_details.DisplayName ).Result

But for now, what you selected in the second Combo box will be texts. To update appropriate values to the list, you need to change the Update property of the Data Card:

LookUp(SPList, PM_details.DisplayName = ComboBox2.Selected.Result).PM_details

Best regards,
DhivyaSL 13 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked. Thank you so much 😀
DhivyaSL 13 on at

Like
a
(1)

Report
Copy link

Link copied!

is there any solution to apply same concept in SharePoint forms (without using customized powerapps form) ?