cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
APM1994
Frequent Visitor

Get Latest Record of a Certain Keyword

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

1 ACCEPTED SOLUTION

Accepted Solutions
Manan-Malhotra
Skilled Sharer
Skilled Sharer

 

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?

View solution in original post

3 REPLIES 3
Manan-Malhotra
Skilled Sharer
Skilled Sharer

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

Try implementing this code

I hope this helps!

I get the error "Expected Text Value"

Manan-Malhotra
Skilled Sharer
Skilled Sharer

 

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?

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,222)