Hi @Anonymous,
If you want to get the files in the site including all the libraries in the Subsite, I am afraid there is no way to rely on the existing action to get directly.
You could use Get all lists and libraries to get the library in the specified site, but it will not include the subsite, you must specify the subsite address.
If you want to implement such a requirement in this Flow, you need to do some preliminary preparations.
- Collect all parent site address and subsite address, store them in an array, and then traverse these site addresses.
Basic format:
[
{
"SiteAddress":"https://company.sharepoint.com/sites/barryTest",
"SiteName":"barryTest"
},
{
"SiteAddress":"https://company.sharepoint.com/sites/barryTest/testsub",
"SiteName":"TestSub"
}
.
.
.
]
- Then initialize another array variable to store the contents of the Html Table.
- Traverse the SiteAddress variable and configure the SiteAddress property value in Get all lists and libraries action to get all the Libraries in the current Site.
- Iterate over the value of Get all lists and libraries action to determine if the current item is library.
- If yes, configure Get files action to use the content of the previous action output.
- Iterate over the value of Get files action output to determine whether the file of the current item is uploaded today.
- If so, the relevant information is appended to the TableContent variable via the object format.
- Finally, the variable TabelContent is used as the content of the Html table.
The main thing is to edit the site Name and Site address in the variable beforehand, according to the given format.
You could consider using Excel table to store this relationship, but I don't think it is necessary to add an extra connector.
Please take a try.
Best Regards,
