Share
Report
8Hi there,
Not 100% sure whether this is something I can achieve with Power Automate but thought I'd give it a go!
To provide some background, my organisation produce and provide various policy documents for a range of clients, and historically whenever these documents were updated we simply logged the new version number (Corresponding with what it is on SharePoint) in the footer of the document itself, however recently it was decided that going forward we would instead include a table within the document which encompasses the entire revision/review history of the document (Predominantly the major version history), see below example:
Rather than having to enter this information manually each time, my aim is to make it so that whenever a policy document is updated, the new major version and relevant information is automatically logged in the revision/review history table inside the document - with the latest version number being pulled by a Get File Properties action, and the Review Date and Reviewed By options being sourced from SharePoint Column values.
To start I added some Plain Text Content Control options into the table in the document so that I could insert the values into them:
See below the automation itself:
When I make an appropriate change and the automation triggers, it works and the document version and values from the SharePoint columns are added into the table within the policy document successfully - see the version 5.0 entry in the screenshot which has been added by the automation:
What ideally would happen now is that when the policy document is next updated after that last entry, the new version info (in this example, version 6.0) and the SharePoint column values would be automatically entered into the next available table row, but I'm not sure how to implement this? Basically, I want the table updated with the new data whilst retaining the previously logged data, as it stands, when I update the document again and the automation runs in its current form, it simply overwrites the existing row - See below screenshot where the entry for version 6.0 just overwrites the version 5.0 entry, whereas ideally each automated entry to be in it's own separate row on the table.
Hopefully that makes sense! As I say I'm not 100% sure that this is something I can accomplish just using Power Automate, or if there's an option in MS Word that would allow me to achieve this, but any assistance would be appreciated!
Thank you!
All responses (
Answers (
