Multiline text column( Get only latest version of data)

(0) Share

Report

Posted on by JimmyW

2,563

I have a multiline text column in a SharePoint online list. I have versioning turned on.

I dont use append text due to my setup it's not possible. (Modern look and so on)

Now i want to extract only the latest input from this mutliline text column. For example.

I type "Hello" i can extract hello and send as a email. Next time i edit this case i type "Hello Again" my email is not sent containing both "Hello" and "Hello Again" i would like to only send the latest added text to the column. How can i extract that? Usinng versioning i can maybe compare? But how do i only get the latest added text in that column?

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @JimmyWork

Please have a look at this link.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Version-field-in-a-SharePoint-list-doesn-t-appear-in/td-p/141454

Another way you could think is add a new multi-line column in your Sharepoint list. When ever the other column gets updated trigger a flow to append the new column. This way you don't need to use version history api call to retrieve all the past updates.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@abm Thank you for answering.

I cannot use the solution running a extra flow and copy to a new column. Dont think this is a very good way of doing it.

For the Version history i already pull this out but i dont know how to sort and compar 1 version to another and only get the data i want. This can be explained like this.

Version 1: Column field "Comments" Contains "Hello"
Version 2: Column field "Comments" Contains "Hello" plus the new comment "Hello 2"

Now this i can sort using versioning and only get foir example "Hello 2"

Now on Version 3 Column field "Comments Contains "Hello" and "Hello 2" plus new comment "Hello 3"
This means when i compare version i will still get more and more comments just not the comment from the version below.

See flow and results after 3 comments.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @JimmyWork

Could you please post a screenshot of your comments run history?

Thanks

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
Well im actually doing something right, currently im pulling everything except the new comment

Initialize Variable i have.
body('Parse_JSON')?['d']?['results'][1]['ColumnName']
With this i pull everything except the latest comment.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @JimmyWork

Did you tried the index 0?

Thanks

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@abm The flow for the comments is not the one im using to test. My comments flow is huge with alot of other checks in it im just building this side flow to see if i can get the latest comment before i add it to the real comments flow

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@abm Yes i then get all the comments, so maybe i can do something with that? Compare it?

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
Im stuck.
Basicly i just want the latest entered data from a sharepoint column.

If i use below i can get everything except the latest comment.
body('Parse_JSON')?['d']?['results'][1]['ColumnName']
If i use below i can get everything including the new comment (i can also just use the Columns dynamic content as it contains the latest data.
body('Parse_JSON')?['d']?['results'][0]['ColumnName']
Now how can i compare or only extract the 1 single added comment thats new without getting all the other comments?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @JimmyWork

Try adding $top=1 in your query. This way it will return only one result. If you not getting the latest version then extend the query orderby as well.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (1)

Report

@abm Thank you for helping me.
Exactly where should i add $top=1

Was this reply helpful? Yes No