Files uploaded to specific folder in document library

[Anonymous]

Good afternoon! @ScottShearer helped me with getting a list of files uploaded to the document library in the thread below, but I'm having an issue getting the Flow to work if a file is uploaded to a specific folder in the Library.

https://powerusers.microsoft.com/t5/Building-Flows/Aggregate-list-of-files-uploaded-to-SharePoint-On...

The solution in the above thread only works if there are files uploaded to the base folder of the document library. It will not work for a subfolder.

I cannot find any option that will allow me to add the subfolders. I am only allowed to select the Document Library. Is there a custom value I can use that will pick up if a subfolder is uploaded?

[v-yamao-msft · Accepted solution]

Hi @Anonymous ,

Action Get files (properties only) will return files stored in sub folders.

I have made some modifications on the flow you provided.

In my SharePoint Library22, there is a subfolder named as “email message” within which there is an excel file named as “CommonIssues for PowerApps”.

In the flow, add action Filter array after the action Get files (properties only). Select value from Get files, and set its condition as File name with extension contains ‘.’.

Add action Create HTML table. Select Body from Filter array, and configure its headers with the following code:

filename: item()?['{FilenameWithExtension}']

createdby: item()?['Author']?['DisplayName']

All the files could be got from the library, including files stored in subfolders.

Images for your reference.

Best regards,

Mabel