Forum Discussion

SunnySchindler's avatar
SunnySchindler
Icon for Helper I rankHelper I
4 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

Thanks

Sunny 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 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
      4 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!