Forum Discussion

jamiers's avatar
jamiers
Helper I
2 years ago
Solved

Issue Pulling Current FIle Directory Contents in Visual

Hello All,

 

I'm using the following PowerQuery:

 

let
    Source = SharePoint.Files("https://americanredcross-my.sharepoint.com/personal/my_email_address", [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Folder Path], "https://americanredcross-my.sharepoint.com/personal/my_email_address/Documents/Regional DWE Power BI Tools/Power BI Data Pulls/")),
    #"Reordered Columns" = Table.ReorderColumns(#"Filtered Rows",{"Name", "Date modified", "Content", "Extension", "Date accessed", "Date created", "Attributes", "Folder Path"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Reordered Columns",{"Name", "Date modified"}),
    #"Sorted Rows" = Table.Sort(#"Removed Other Columns",{{"Name", Order.Ascending}})
in
    #"Sorted Rows"

 

 

This is what comes out as results:

 

 

You can see that the Last Modified Dates are updating, but I have moved several files out of this directory and they are still showing on update.  Here is a list of what is actually in that directory.  Things noted in BLUE do not show below in the actual directory/folder in OneDrive.

 

Any ideas on how to fix this so it properly reflects what is in the directory/folder in OneDrive?

 

  • Text.StartsWith([Folder Path], "https://americanredcross-my.sharepoint.com/personal/my_email_address/Documents/Regional DWE Power BI Tools/Power BI Data Pulls/")

    That filter includes all subfolders.

1 Reply

  • Text.StartsWith([Folder Path], "https://americanredcross-my.sharepoint.com/personal/my_email_address/Documents/Regional DWE Power BI Tools/Power BI Data Pulls/")

    That filter includes all subfolders.