Unanswered

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

(0) Share

Report

Posted on by JELMDX

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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Gdarmon Outlook 372 on at

Like (0)

Report
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:
Add the Send an HTTP request to SharePoint action to your flow.
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.
In the Headers field, add a new header with the name ‘Accept’ and the value ‘application/json;odata=nometadata’.
Add the Parse JSON action to your flow and use the output from the Send an HTTP request to SharePoint action as the content.
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.
Use the Get property action to retrieve the specific column value you are interested in from the parsed JSON response.
Br,
Gill

Was this reply helpful? Yes No
JELMDX 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No