Forum Discussion

SunnySchindler's avatar
SunnySchindler
Icon for Helper I rankHelper I
5 years ago

How to Power BI list Document Property (Last Modified Person Name) for files in folder?

How to search Windows 10 folder for Last-Modifed-By which is part of Microsoft Document Property (screenshot below) ? This may be part of MetaData according to search by author - Microsoft Community ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

That attribute is not exposed .

let
    Source = Folder.Files("C:\Users\xxx\Downloads"),
    #"Expanded Attributes" = Table.ExpandRecordColumn(Source, "Attributes", {"Content Type", "Kind", "Size", "ReadOnly", "Hidden", "System", "Directory", "Archive", "Device", "Normal", "Temporary", "SparseFile", "ReparsePoint", "Compressed", "Offline", "NotContentIndexed", "Encrypted", "ChangeTime", "SymbolicLink", "MountPoint"}, {"Attributes.Content Type", "Attributes.Kind", "Attributes.Size", "Attributes.ReadOnly", "Attributes.Hidden", "Attributes.System", "Attributes.Directory", "Attributes.Archive", "Attributes.Device", "Attributes.Normal", "Attributes.Temporary", "Attributes.SparseFile", "Attributes.ReparsePoint", "Attributes.Compressed", "Attributes.Offline", "Attributes.NotContentIndexed", "Attributes.Encrypted", "Attributes.ChangeTime", "Attributes.SymbolicLink", "Attributes.MountPoint"})
in
    #"Expanded Attributes"
SunnySchindler's avatar
SunnySchindler
Icon for Helper I rankHelper I
5 years ago

Since "Last Modified Person Name" is not exposed, where to find listables for PowerPoint 365 documents (similar to Excel Sheets & Names can be listed) ? I'm hoping to find document last modified by Author without opening each document (just to ensure content by rightful person). There's always programming like PowerShell but my company restricts programming. 

Thanks Ahead!