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
Continued Contributor
Continued Contributor

 

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
Continued Contributor
Continued Contributor

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

Try implementing this code

I hope this helps!

I get the error "Expected Text Value"

Manan-Malhotra
Continued Contributor
Continued Contributor

 

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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 (4,833)