Forum Discussion
File metadata
Hello I am using power query to grab the data and filenames from multiple files with different headers in some cases (all have one worksheet) into a file with one worksheet.
Is there a way where I can also grab created/modified by and if possible (a nice to have) created/modified date
thanks
I am closing this ticket. Solution was to bring the meta data using VBA
5 Replies
harry1605
If I assume your are using folder connector (Folder.Contents) or sharepoint foler connector (Sharepoint.Contents), then you will be able to pull created and modified date. While loading do not click on combine data, instead click on transform data then you will be able to find those columns. Hope this answers your question.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Hello Tharun,
Thank you. However, from my checks I am not able to being created by or modified by.
Any suggestions?
harry1605
As you can see here:If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thanks Tharun,
I understand the confusion since I am looking for the person which looking at the metadata this is Authors and Last saved by. Are you able to show this detail?
I am closing this ticket. Solution was to bring the meta data using VBA
