File metadata

[harry1605]

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

[harry1605 · Accepted solution]

I am closing this ticket.  Solution was to bring the meta data using VBA

[harry1605]

Hello Tharun,

Thank you.  However, from my checks I am not able to being created by or modified by.

Any suggestions?

[tharunkumarRTK]

@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

[harry1605]

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?

[tharunkumarRTK]

@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