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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-jefferni on at

Like (2)

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

Was this reply helpful? Yes No
DhivyaSL 13 on at

Like (0)

Report

It worked. Thank you so much 😀

Was this reply helpful? Yes No
DhivyaSL 13 on at

Like (1)

Report

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

Was this reply helpful? Yes No