Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Customizing sharepoint list for the purpose of cascading column list

(0) ShareShare
ReportReport
Posted on by 212

I have a SharePoint list called FileSummary. I have defined look up columns in the FileSummary SharePoint list for the purpose of creating a cascading list. For example, Vertical column is a lookup to source list Vertical and Title only column in the list. VerticalMattertype column is a lookup to source list VerticalMattertype, Title and Vertical are two columns in this list.

 

I am trying to filter VerticalMattertype column based on a value selected in the Vertical column. If the choice in the Vertical field is Corp, then one of the options to display should be Dev in the VerticalMatterType.

 

In the Vertical List: I have the following records in the Title column: CMF, Corp, FSH, etc

In the VerticalMattertype List I have two columns with the following records in the Title column: Dev, Fin, Lit, etc

and in the Vertical column: CMF, Corp, FSH, etc.

 

In powerapps, I have made the required data connections to the required lookup lists.

 

DataCardValue 3 (Vertical) Items is defined as Choices([@FileSummary].Vertical)

 

In the subsequent field for VerticalMattertype: DataCardValue4 Items field :

I have tried the following expressions: Filter (VerticalMattertype, Vertical = DataCardValue3.Selected.Result)

&  Filter(VerticalMattertype, Vertical/Title = DataCardValue3.Selected.Vertical/Title)

 

@abm 

  • Verified answer
    mthiru_0023 Profile Picture
    mthiru_0023 212 on at
    Re: Customizing sharepoint list for the purpose of cascading column list

    Thanks @WarrenBelz . I will give this a try. For the interim, work around, I ended up replacing the value control inside the data card to a dropdown control. Also had to remove the look up column types from my SharePoint lists to a text column types. 

     

    mthiru_0023_0-1676644183171.png

     

  • WarrenBelz Profile Picture
    WarrenBelz 145,508 on at
    Re: Customizing sharepoint list for the purpose of cascading column list

    Hi @mthiru_0023 ,

    Assuming your values are correct, try this

    Filter(
     VerticalMattertype, 
     Vertical = DataCardValue3.Selected.Result &&
     'Vertical/Title' = DataCardValue3.Selected.'Vertical/Title'
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard