Answered

How to retrieve items, depend on latest date?

(0) Share

Report

Posted on by TomasG

255

Hello,

I have SP list with items, which represent covid test employee.
Example:
employee A - 20.3.2021
employee B - 28.3.2021
employee A - 17.03.2021

And I make app, where I need to retrieve only the latest test of employee.
Result should be:
employee A - 20.3.2021
employee B - 28.3.2021

But, I dont know, how to filter it. Or if use power automate/ logic apps to get required items?
Is in power apps some function for it, or another way to get it?

Thanks for any advice.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@TomasG

All SharePoint lists have a hidden ID column that is sequential. To see the latest items, you can do this as the Items property of a gallery or datatable. This function is delegatable, meaning it will work no matter how many items are in your list.

Sort(Yourlist,ID,Descending)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-Apps-Select-Max-Row-for-Each-Group/m-p/762170

here is a forum post describing something similar I used to find the most recent record.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TomasG,

Based on the issue that you mentioned, do you want to filter out the latest test for each employee?

Could you please share a bit more about the scenario,is this date a Date and Time column?

I think GroupBy() function could achieve your needs.

I just assume that you have a Date and Time column.

Where do you want to filter out the records, Gallery?

Add a Gallery and set the Items:

GroupBy(SPLits,"employee","Gemp")

Set the Text of the Label within as below:

First(Sort(ThisItem.Gemp,Date,Descending)).Date

Regards,

Qi

Was this reply helpful? Yes No