Hi Power Automate Community,
I have recently been put in charge of organizing the document history for an organization that did not use document revisions tables for the last 15 years. We recently passed a major audit, but one of the minor nonconformities was to have traceability for document revisions.
I have the Obsolete folder which has subfolders that include different document types (Lets call them Docs, FORMs, SOPs, etc)
Inside these subfolders I would like to do the following
- Create a document number folder for each unique document version (DOC-1 Title, DOC-2 Title, DOC-3 Title).
- Rename each document file to match the folder from step one and include the Revision (DOC-1 Title Rev A, DOC-1 Title Rev B, DOC-1 Title Rev C, etc.). Before/After renaming to match the folder, move into the document number folder created in step 1.
There are two major roadblocks to performing this:
- The document naming was never made to be uniform. For a document that should be named "DOC-1 Title Rev A" could be named any of the following ways:
- DOC1 Title
- DOC1a Title
- DOC-1-a Title
- DOC Title 1a
- Inside each document, the footer contains the Revision: Character in one of the lines and the Document Number and title are both in the header. Therefore I tried to use "Get Details of Window and grabbed the UI element for the header and footer. However, When I ran my flow, the flow pulled the entire document's body of text.
Any advise as to how I should approach this problem would be greatly appreciated.

Report
All responses (
Answers (