Forum Discussion
Filter Old Draft Folders
The grouping is currently set at the Draft folder level, which is why you’re seeing one file per Draft instead of one per PR folder.
You should group at the PR-26*** level so all Draft folders are considered together. Then, use the maximum modified date within each group and filter to that row. This will give you only the most recent file across all Draft folders for each PR.
If you still get multiple rows, sort within each group and keep just the top row to ensure a single result.
Please try this approach and let us know how it works for you.
Connect to the Sharepoint site via "Sharepoint Folders", click "Transform data" *
Filter for the desired file name patterns (and folder names if needed)
Sort by Last Modified Date descending
Keep the top 1 row.
*) This will give you all the files in all the folders on that sharepoint site.
I think maybe explanation of what the final result should be was confusing. Keep top row 1 gives me only the most recent file from the entire PR-26*** list of files. I want the most recent file from the group of "Draft" folders in each PR-26*** folder with the file path to each file. Also I should mention there is no SharePoint involved, so this would all be "from file - from folder".
Connect to the parent folder, transform data
Group by Folder Path, aggregate by Max Last Modified Date but also include "All Rows"
Expand the "Rows" column
filter all rows where the Last Modified Date equals the Max Last Modified Date
I'll give that a shot on Monday when I'm at work and let you know how it goes.
Just following up did you have a chance to test this on your side? Please let us know how it went or if you’re still experiencing the same issue.