You’re offline. This is a read only version of the page.
4
I have a flow that needs to retrieve a specific Column value from the previous SharePoint List record. Using the following method takes 30 seconds currently and will probably take more time with the more records that are added to the list.
I'm currently using Get Items, with 'Order by - Created desc' and 'Top Count -1'
Is there a better\quicker way to obtain the values of the previous record?
Thank you
continue
@DarmonGill Thanks for the response, i perhaps put a red herring in my description....
"retrieve a specific Column value from the previous SharePoint List record" this should probably be 'retrieve a specific Column value from the last SharePoint List item created'.
I'm not after the specific version of a SharePoint List item.
Does this make a difference?
Hi,
One way to achieve this is by using the Send an HTTP request to SharePoint action instead of the Get items action. You can use the following REST API endpoint to retrieve the previous version of a SharePoint list item:
Share
Report
All responses (
Answers (
_api/web/lists/GetByTitle('ListName')/items(ID)/VersionsYou can then use the Parse JSON action to parse the response and retrieve the specific column value you are interested in.
Here’s an example of how you can use this approach:
Br,
Gill
#1
rpersad
16
#2
David_MA
10
Super User 2025 Season 1
#3
Michael E. Gernaey
8
Super User 2025 Season 1
