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

Like (0) Share

Report

Posted on 12 Sep 2022 06:23:29 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:

Connecting to Data

All responses (3)

Answers (1)

DhivyaSL 13 on 12 Sep 2022 at 09:56:49

Like (1)

Report

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

is there any solution to apply same concept in SharePoint forms (without using customized powerapps form) ?
DhivyaSL 13 on 12 Sep 2022 at 09:31:48

Like (0)

Report

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

It worked. Thank you so much 😀
Verified answer

v-jefferni on 12 Sep 2022 at 07:36:07

Like (2)

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

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,