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
