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)
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.
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