Get Latest Record of a Certain Keyword

[APM1994]

I have a main list which has multiples of a certain entry which are all numbered in the title:

EG: Dog 1, Dog 2, Dog 3, Cat 1, Cat 2, Elephant 1 etc

However, there is also a column for 'Animal'

How can I get the latest entry, for example, for 'Dog'

I'm currently using "Last(MainList).Animal.Value" which will give me the latest entry. But I specifically want to extract the latest Dog entry.

Worth noting that the 'Animals' column is a lookup to another list

[Manan-Malhotra]

Last(Filter(MainList,Animal.Value="Dog"))

Try implementing this code

I hope this helps!

[APM1994]

I get the error "Expected Text Value"

[Manan-Malhotra · Accepted solution]

Last(Filter(MainList,Animal.Value="Dog")).Animal.Value

Edited the code a bit 

Please Accept as Solution if it solves your question Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/manan-malhotra-vfx/

Want to support me! Buy me a Cup of Coffee?