web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Previous Item take...
Power Automate
Unanswered

Get Previous Item takes forever.......

(0) ShareShare
ReportReport
Posted on by JELMDX 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.

JELMDX_0-1701947554142.png

I'm currently using Get Items, with 'Order by - Created desc' and 'Top Count -1'

JELMDX_1-1701947722185.png

Is there a better\quicker way to obtain the values of the previous record? 

Thank you


continue 

Categories:
General topics
I have the same question (0)
  • Gdarmon Outlook Profile Picture
    Gdarmon Outlook 372 on at

    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:

    _api/web/lists/GetByTitle('ListName')/items(ID)/Versions

    You 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:

    1. Add the Send an HTTP request to SharePoint action to your flow.
    2. In the Uri field, enter the REST API endpoint mentioned above and replace ‘ListName’ with the name of your SharePoint list and ‘ID’ with the ID of the item you want to retrieve the previous version of.
    3. In the Headers field, add a new header with the name ‘Accept’ and the value ‘application/json;odata=nometadata’.
    4. Add the Parse JSON action to your flow and use the output from the Send an HTTP request to SharePoint action as the content.
    5. In the Schema field of the Parse JSON action, define the schema for the JSON response. You can use the Generate from sample option to generate the schema automatically.
    6. Use the Get property action to retrieve the specific column value you are interested in from the parsed JSON response.

    Br,

    Gill

  • JELMDX Profile Picture
    JELMDX 4 on at

    @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?





Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 953

#2
Valantis Profile Picture

Valantis 810

#3
Haque Profile Picture

Haque 622

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans