Unanswered

How to pull only the most recent items in a SP List based on Time Received

(1) Share

Report

Posted on by Epidot

Hi,

I have a SharePoint List which cumulates ticket updates for incidents. I need to create a Flow that send an email when an incident has breached the next update due time. The problem i have is that there will often be multiple rows in the list for the same incidents (older updates). I need the flow to only pick out the current 'Next update Due' for each incident.

Example below in a table (made up). Highlighted in yellow would be the most recently received updates. Those are the ones i need and the rest can be ignored. Table ordered newest to oldest.

My flow would be

1) Get SP list items

2) Get newest update for each incident only

3) condition (If UTCnow is less than 'Next Update Due' . Send email

Any help appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report
Dear Epidot,

Seems like you need some kind of embedded filter or double level filter or ... not sure what the right term for this is. In any case, I have yet to see this is in Power Automate actions. The standard filter options in actions seem kinda limited, mostly it does not even allow boolean operators (AND, OR, ...).

Can't you just filter the array and then filter again? I know it feels kinda rough, but if it works, it works ... and speed should not be an issue if it is just filters.
Something like:
Get the overdue date items.
Filter array by incident number.
Sort by newest date.
Get the first item only. (first()).
Maybe there is a double layer filter possible in the 'Select array' function, but I have yet to see it. Would be interested if someone knows this though.

Happy flowing,
Koen

Was this reply helpful? Yes No
Epidot 94 on at

Like (0)

Report

Thanks,

Bit stuck after this bit. I've got items that are breached and i've ordered by newest to oldest.

Unsure how to then pick out the first of each incident Number..

Was this reply helpful? Yes No
Han2 10 on at

Like (0)

Report

Tom Riha's solution "How to get only the last item from a SharePoint list in Power Automate" might get you there, or a step in the right direction at least. He orders the hits by ID and takes the top hit, but I reckon you could order it by the modified date instead.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Run your own ODATA query with grouping.

Grouping and Aggregation in OData Client - OData | Microsoft Learn

Example 2.

Was this reply helpful? Yes No