web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate - Copyi...
Power Automate
Unanswered

Power Automate - Copying Head and Foot Text from Word .doc & .docx into Excel on excel file

(0) ShareShare
ReportReport
Posted on by

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

  1. Create a document number folder for each unique document version (DOC-1 Title, DOC-2 Title, DOC-3 Title).
  2. 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:

  1. 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
  2. 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.Flow Document Header.pngFlow Document Footer.pngFlow Attempt 1.png 

I have the same question (0)
  • Benny_1857 Profile Picture
    124 on at

    Save the word to PDF and use Excel Power Query to load them.

    I draft a word, then save as PDF with 3 pages

    Benny_1857_0-1642553217622.pngBenny_1857_1-1642553246823.png

    Benny_1857_2-1642553340457.png

    So my suggestion is

    1.PAD to save Word files to PDFs

    2. Depend on your request. One PDF for One Excel or many PDFs conbine in one Excel

        1) Put PDFs into one folder

        2) Open Excel use PQ load the folder
        3) Normally it only read one page at first time, so you need to change the Transform Sample File in PQ
        4) Close and Load

         (I tried 3 PDF with different pages and it works)

    3. PAD to run the PQ and Save as Excel
    Becuase it is a little complicated if you do not use Excel PQ before, I could make a steps PDF if you needed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 557

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 264 Super User 2026 Season 1

Last 30 days Overall leaderboard