Answered

Sending one flow email detailing all files uploaded today across site collection as a summary

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have a requirement as follows: I would like to create a flow that sends one email at the end of the day to Supervisor detailing what files were uploaded today in which document libraries along with site name where doc library is setup and by whom?

Ideally I know that with each document library we can attach a flow which can trigger whenever a document is uploaded but that will be then multiple emails sent out and i do not want that. Basically supervisor needs to see an email summary that can show info about which users uploaded documents today in which libraries along with site name where doc library resides across the sire collection. Is this possible to implement, if so please help with a solution.

P.S: there should only be one email going out in a day detailing about all file uploads.

All responses (3)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Re: Sending one flow email detailing all files uploaded today across site collection as a summary

Hi @Anonymous,

Have you tested the workaround I have provided?

Do you need additional assistance?

As for the other question you mentioned, it seems that someone has given a workaround, try it.

Best Regards,
Community Power Pla... on at

Like (0)

Report

Re: Sending one flow email detailing all files uploaded today across site collection as a summary

@v-bacao-msft
Great thanks, i will test this out. Can you also check this thread where I posted another question: https://powerusers.microsoft.com/t5/Building-Flows/Consolidated-Email-to-the-assigned-user-weekly-for-tasks-due/m-p/208134, if you can suggest an answer that would be great, thanks.
Verified answer

v-bacao-msft on at

Like (1)

Report
Re: Sending one flow email detailing all files uploaded today across site collection as a summary

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,