Filter ListB on selected item from ListA, return most recent date

[KeithD]

I have a combobox that looks at SharePoint 'ListA' shows ColumnA & ColumnB is searchable on ColumnA

Under the combobox i have a number of textinputs in view displaymode that return other values from ListA based on selected item in combobox

Im trying to add another textinput that takes the selected item from combobox, look up ColumnA value in ListB ColumnC and returns ListB ColumnD

I can make this work with a lookup ....

LookUp(ListB, ColumnC = Combobox.Selected.ColumnA, ColumnD)

How ever ListA ColumnA value can appear in ListB ColumnC multiple times,

ListB ColumnD is a date and i need to return the most recent date when there are multiple matches in ColumnC

I understand i need to use Filter instead of lookup then sort the results but im struggling to make this work,

Can any one offer some direction?

Thank You

[WarrenBelz · Accepted solution]

Hi @KeithD ,

You can do this with a LookUp

LookUp(
   Sort(
      ListB,
      ColumnD,
      Descending
   ),	  
   ColumnC = Combobox.Selected.ColumnA
).ColumnD

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.

Visit my blog Practical Power Apps

[KeithD]

Worked perfectly thank you, should have thought of doing that my self.