Unanswered

MS Flow + Obtaining all data from Field Set To "Append Changes to Existing Text"

(0) Share

Report

Posted on by bclarkuncc

I am trying to find a way to obtain all previous information entered into a Sharepoint list item field set to "Append Changes to Existing Text". Any thoughts?

I have the same question (0)

All responses (5)

Answers (0)

Brad_Groux 4,556 on at

Like (0)

Report

Re: MS Flow + Obtaining all data from Field Set To "Append Changes to Existing Text"

You'd have to be more specific for us to offer any direct insight. What you are seeking to accomplish from the limited information you have provided can certainly be done.
I'd encourage you to visit the Flow Templates and search "SharePoint List" to see many templates that work with SharePoint Lists, and use those as learning guidance and/or a starting template and build from there.
You can make it as simple, or as complex as you need. As an example, I did a quick Bing search and found this blog post, Retrieving single item from sharepoint list in microsoft flow.
If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.
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
bclarkuncc 21 on at

Like (0)

Report

Re: MS Flow + Obtaining all data from Field Set To "Append Changes to Existing Text"

More Details:

I have created a column/field in Sharepoint as Type "Multiple Lines of Text". I have also enabled the setting "Append Changes to Existing Text" to track/maintain entries into this field as it is updated. The, in MS FLow, I have build a flow that sends an email when a condition in Sharepoint is triggered. The event triggers correctly and my email sends, but for the field referenced it is only sending the most current update. I would like to get all updates ever entered for this field. I believe Sharepoint stores them as different versions. Does that help?

Was this reply helpful? Yes No
Brad_Groux 4,556 on at

Like (0)

Report
Re: MS Flow + Obtaining all data from Field Set To "Append Changes to Existing Text"

You would like the data from the field being updated to also show previous data updates - aka the version history? Out of the box, you can't pull previous version data from a SharePoint list item.
You could create an "Update Tracker" SharePoint List that adds a new item each and every time an item is updated on the first SharePoint List.
Outside of that, your only real option is some heavy lifting with SharePoint's API for grabbing the version history of an item. This can be done with Flow, but is outside of the realm of this help forum. See here for more:
http://www.sharepointdiary.com/2015/07/sharepoint-online-update-list-items-using-powershell.html
https://stackoverflow.com/questions/24423657/sharepoint-2013-get-splistitem-versions-via-rest
https://www.c-sharpcorner.com/UploadFile/anavijai/how-to-get-the-file-versions-in-sharepoint-2013-online-using/
https://social.msdn.microsoft.com/Forums/en-US/79945c1d-1581-4441-bc13-14d119aa6a64/document-version-history-via-rest-api?forum=sharepointdevelopmentprevious
If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.
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
bclarkuncc 21 on at

Like (0)

Report

Re: MS Flow + Obtaining all data from Field Set To "Append Changes to Existing Text"

So...I ended up getting the version information I needed using the flow below. The only issue I am having is I lose the context of who/when an item was updated (Sharepoint shows this in the field). Any thoughts?

Was this reply helpful? Yes No
danfoxley-tc 2 on at

Like (0)

Report

Re: MS Flow + Obtaining all data from Field Set To "Append Changes to Existing Text"

@bclarkuncc
Were you able to get the dates?
Can you share how you got the JSon Schema, screenshots?

Thanks,
Dan

Was this reply helpful? Yes No