
Announcements
Hi,
I am trying to extract the following data from a word file:
I can get things like "Title" and "Document Number" with the 'get file metadata' function, however I cant get the thing that I need which is "Author" in the related people field.
This is for an approval loop where I wanted the person submitting the approval to be the document author (even if it was submitted by someone else, hence can't use modified by) I also cant use 'created by' as this would be whoever put the file in the particular location!
Any help would be appreciated!
Hi @Gennaro87 ,
The metadata 'author' seems to be saved in the file content instead of SharePoint.
Step:
1\ Download the .docx file to local drive
2\ Zip the file
3\ Open the zip file with WinRAR and open XML file 'core.xml'.
Power Automate can get file content but cannot parse it.
Reference:
https://stackoverflow.com/questions/37116448/how-to-acces-the-author-name-and-other-docx-metadata
Best Regards,
Wearsky