Skip to main content

Notifications

Community site session details

Community site session details

Session Id : BvzAnqD7GkWi2oZ2a3p4Lr
Power Apps - Building Power Apps
Answered

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

Like (0) ShareShare
ReportReport
Posted on 12 Sep 2022 06:23:29 by 13

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 ListSharepoint 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:
  • DhivyaSL Profile Picture
    13 on 12 Sep 2022 at 09:56:49
    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_0-1662977019895.png

     

  • DhivyaSL Profile Picture
    13 on 12 Sep 2022 at 09:31:48
    Re: Cascading drop-down for "Person field in SharePoint list".

    It worked. Thank you so much 😀

  • Verified answer
    v-jefferni Profile Picture
    on 12 Sep 2022 at 07:36:07
    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 20

#2
BCBuizer Profile Picture

BCBuizer 10 Super User 2025 Season 1

#2
LC-26081402-0 Profile Picture

LC-26081402-0 10

Overall leaderboard
Loading started