Answered

Trouble getting the corrrect values of a Modified Field for an specific version of an item in Sharepoint.

(0) Share

Report

Posted on by IonLion

Hi, I been trying for a while to extract some specific data from a previous version of a Sharepoint item to then be able to copy it to another column in my list in bulk for record purposes. I've managed so far to get who edited the document in the 2.0 (first edition) version successfully of the item but the Modified valued returned doesn't coincide with the 2.0 version. For some reason when I test the Flow I get the Modified date of the 5.0 version of the document not the expected 2.0 version information. Is it possible to get that specific date for the first edit?

Thank You!

Pauto.png

All responses (2)

Answers (1)

Verified answer

IonLion 23 on at

Like (1)

Report

Re: Trouble getting the corrrect values of a Modified Field for an specific version of an item in Sharepoint.

The value I was given was correct but power automate was changing the time format from my local time zone to the UTC time zone. I had to use the action "Convert time zone" and the output of that gave me the correct time. Thank you annajhaveri for the help.
annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

Re: Trouble getting the corrrect values of a Modified Field for an specific version of an item in Sharepoint.

@IonLion i just tried testing on my end using the REST API in send http to SharePoint action and it works, it gives me modified date of given version, can you double check? You can try pasting the URI in format <siteurl>/<uri from your flow) in browser and see what modified date are you getting?