web

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

News and Announcements icon

Power Platform CommunityForums Power Apps lookup most recent val...

Power Apps

Answered

lookup most recent values in related sharepoint list

(0) Share

Report

Report

Posted on by cheezy

148

i have an app that looks at two sharepoint lists - a user can select a record from a gallery (list 1) and record multiple progress notes (list 2)

On the primary gallery i have a field in an attempt to show the latest current state of the progress note created:

LookUp('Progress Notes',RefID = ThisItem.ID, 'Current State'.Value)

This returns the first Current state created - is there a way to show the most recent?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @cheezy ,

Like this

LookUp( Sort( 'Progress Notes', ID, Descending ), RefID = ThisItem.ID, 'Current State'.Value )

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

Was this reply helpful? Yes No
Silvester. Akakpo 783 on at

Like (0)

Report
hi @cheezy ,
This just came to mind. Worth a try though.
ClearCollect(ColValue,Filter('Progress Notes',RefID = ThisItem.ID, 'Current State'.Value)); Set(VarValue,Index(ColValue,CountRows(ColValue)))

Was this reply helpful? Yes No
cheezy 148 on at

Like (0)

Report

thanks this works a treat - trying to figure out the syntax always a challenge!

Was this reply helpful? Yes No

Join the conversation