Issue Pulling Current FIle Directory Contents in Visual

[jamiers]

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?

[lbendlin · Accepted solution]

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.