Forum Discussion
jamiers
2 years agoHelper I
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
- lbendlinSuper User
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.