display major version published date in a sharepoint column

%3CLINGO-SUB%20id%3D%22lingo-sub-1788863%22%20slang%3D%22en-US%22%3Edisplay%20major%20version%20published%20date%20in%20a%20sharepoint%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1788863%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EI%20have%20a%20policy%20document%20library%20with%20major%2Fminor%20versioning%20turned%20on.%20I%20have%20a%20requirement%20to%20set%20a%20review%20interval%20for%20my%20documents.%20The%20review%20interval%20should%20be%20based%20on%20the%20date%20of%20the%20most%20recent%20major%20version.%20Does%20anyone%20have%20a%20way%20to%20display%20this%20information%20in%20a%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20standard%20%22Modified%22%20column%20will%20not%20work%20for%20this%20because%20that%20could%20and%20will%20change%20if%2Fwhen%20minor%20versions%20are%20created.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20add%20a%20simple%20%22Date%22%20column%20and%20instruct%20my%20users%20to%20enter%20the%20date%20they%20publish%20on%2C%20but%20this%20is%20clunky%20at%20best%20and%20I%20know%20people%20will%20forget%20to%20do%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1788863%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1790725%22%20slang%3D%22en-US%22%3ERe%3A%20display%20major%20version%20published%20date%20in%20a%20sharepoint%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1790725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835224%22%20target%3D%22_blank%22%3E%40ajbitely%3C%2FA%3E%26nbsp%3BYou%20can%20do%20this%20with%20a%20PowerAutomate%20Workflow.%3C%2FP%3E%0A%3CP%3E-%20Add%20a%20Date%20Column%20for%20the%20next%20review%20date%3C%2FP%3E%0A%3CP%3E-%20Set%20the%20approval%20workflow%20to%20calculate%20the%20date%20value%20when%20the%20major%20version%20is%20published%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20written%20a%20blog%20on%20how%20to%20set%20publish%20a%20major%20version%20using%20PowerAutomate%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsteveknutson.blog%2F2019%2F09%2F21%2Fflow-approvals-with-sharepoint-document-publishing%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsteveknutson.blog%2F2019%2F09%2F21%2Fflow-approvals-with-sharepoint-document-publishing%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello All,

I have a policy document library with major/minor versioning turned on. I have a requirement to set a review interval for my documents. The review interval should be based on the date of the most recent major version. Does anyone have a way to display this information in a column?

 

The standard "Modified" column will not work for this because that could and will change if/when minor versions are created. 

 

I could add a simple "Date" column and instruct my users to enter the date they publish on, but this is clunky at best and I know people will forget to do it. 

 

Thanks in advance for your help. 

3 Replies
Highlighted

@ajbitely You can do this with a PowerAutomate Workflow.

- Add a Date Column for the next review date

- Set the approval workflow to calculate the date value when the major version is published

 

I've written a blog on how to set publish a major version using PowerAutomate

https://steveknutson.blog/2019/09/21/flow-approvals-with-sharepoint-document-publishing/

 

 

Highlighted

@Steve Knutson thank you for your reply, but unfortunately, I am not sure your post addresses my question.

 

Creating a Power Automate flow was/is a great idea, but as far as I can tell, there is no way to do an automatic trigger when someone "Publishes". If there was a way to do that I could write the date into another column. (This is a commonly requested item in the Power Automate Ideas forum).

 

I followed your link but it did not address the question at hand. 

 

Best Regards,

Andy

@ajbitely I do this using a 'Send selected file for approval' Flow. You are right, it requires someone to manually run the Flow. I use column formatting to add a link into the library view next to each item to make this easier for the user.