Hopefully this is what you're looking for. It will run the flow daily and get all files created in the last 24 hours. If no files created during that period, then no email will be sent.
See full flow below. I'll go into each of the actions.
Recurrence is set to run daily (you can specify what time of the day you want to send the email).
Get files (properties only) retrieves all the files created in the last 24 hours (excluding folders). Include Nested Items is set to Yes, and the Filter Query uses the following expression.
FSObjType eq 0 and Created ge '@{addDays(utcNow(), -1)}'
//Note: FSObjType eq 0 means Files not Folders. If you only wanted Folders and not Files you would use FSObjType eq 1.
Condition checks to see if any files were created (length of the items returned). If at least one file, then it will continue to send the email within the Yes branch.
length(outputs('Get_files_(properties_only)')?['body/value'])
Create HTML table uses the output (value) from Get files and maps the File Name and Folder Path (you can specify whatever properties you want).
Compose HTML style is just some CSS I've added to make the HTML table look nicer when we send it via email.
<style>
table {
border-collapse: collapse;
}
table td,
table th {
border: 1px solid #ddd;
padding: 10px;
text-align: left;
}
table th {
background-color: #1C6EA4;
color: white;
}
</style>
Send an email uses the output from Compose HTML style and Create HTML table within the Body. I've also added the following expression in the Subject to get the number of files created.
length(outputs('Get_files_(properties_only)')?['body/value'])
If at least one file was created in the last 24 hours, we would get an email similar to this:
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
