web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Select the recent date...

Power Apps

Answered

Select the recent date record by Lookup function

(0) Share

Report

Report

Posted on by venka91

1,119

Hi there,

In my List for a diary farm, i have a animal details with its tag. In a dashboard i would like to show when the animal was last calved.

So i am trying to search the animal record by its tag.

In my OK button, i have written this code.

Set(varAnimalRec, Lookup(myDiary, ear_tag=txt_tagno.Text)

This is giving me the result as below.

Now from this result, i want to see when the animal was last calved.

I have column "Calving Date" as a Date and Time column, which holds the date of calving.

Now i want to filter this result with latest calving date.

Can anyone help how to i filter the lookup result based on latest calving date ?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@venka91

Set( varAnimalRec, Lookup( Sort( myDiary, animal_calvingdate,Descending ), ear_tag=txt_tagno.Text ) )

I am assuming "myDiary" is not a typo.

Join the conversation