Unanswered

Get Most recent item from SharePoint List

(0) Share

Report

Posted on by duncant

278

I have created a flow to get the most recent response from a SharePoint List based on the SharePoint ID value. I have created a temp variable (tempId) initialized to 0. If the SharePoint List ID is greater than the tempId, the tempId is set to the SharePoint List ID. The tempId it set correctly, but when I try to use the tempId to Get an item, it is something completely different.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (2)

Report

I would need to see the flow to understand what you are trying to achieve and how. But here is one method to get the newest SharePoint item that was created - which will be the item with the highest ID:
The ID stored in a variable:
The variable used in a Get item action:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report

@ekarim2020 I am trying to get the most recent response. Instead of ID desc, I used Created desc and Top 5 (I've noticed although you choose one, more items are pulled). I will try using the ...['body/value'][0]... instead.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

The following will get the most recently changed or modified list item from SharePoint:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report

@ekarim2020 When you initialize the variable, does this create an apply to each?

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

The results returned by Get items action is an array (the value property). To access all the items in the array (even if there is only one item in the array) Power Automate uses the Apply to each loop.

To avoid using the Apply to Each loop when we only have one item, we can use an expression:
But there is nothing wrong with using the Apply to Each loop if you want to.

Ellis

____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report

@ekarim2020 I think I am getting the apply each while inside another apply to each, which is why I cannot initialize the variable to that value. Instead, I went ahead and set the top count to one, got the ID directly, and removed the tempId variable.

Was this reply helpful? Yes No