Note if you want to run the report at 6PM each day then you can't just get the files and folders created today otherwise you won't get anything created after 6PM each day.
See summary of flow below that runs daily at 6PM and retrieves files and folders created in the last 24 hours. I'll go into detail for each action below the summary.
Recurrence
This is set to run at 6PM each day based on my time zone (you would put whatever time zone you are in).
Initialize variable - Last 24 hours
This creates a date set to the current time minus a day so 24 hours ago.
addDays(utcNow(),-1)
Get files (properties only)
This retrieves all the files (and folders) where the created date is greater or equal to 24 hours ago (the last time you ran the report). It also has Include Nested Items set to Yes.
Created ge '@{variables('OneDayAgo')}'
If you wanted to only return files (NOT folders) then you could update the Filter Query with the following:
FSObjType eq 0 and Created ge '@{variables('OneDayAgo')}'
Condition - Are there any files
This checks to see if any files and/or folders were returned (created in the last 24 hours) and only continues if there is at least one.
length(outputs('Get_files_(properties_only)')?['body/value'])
Create HTML table
This will build an HTML table passing in the relevant fields from the files returned. You can add whatever fields you want (that are available to you). Note that value in the From field is taken from the Get files action.
Compose Table Style
This is some CSS (Cascading Style Sheet) to style your table to make it look nice when it's sent out via email.
<style>
table {
border-collapse: collapse;
width: 100%;
}
table td, table th {
border: 1px solid #ddd;
padding: 8px;
}
table tbody tr:nth-child(2n+2) {
background-color: #ddd;
}
table tr:hover {
background-color: #ddd;
}
table th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #1C6EA4;
color: white;
}
</style>
Convert time zone
This just takes the date/time from 24 hours ago and converts it into my time zone with a full date/time pattern. Again, you would change this to your time zone. This is used in the email subject and body.
Send an email - Daily summary
Finally you send the email including the converted date/time, CSS table style and HTML Table you generated.
Note that the first Output is from Compose Table Style, and the second Output is from Create HTML table.
Below is an example of what the email would look like.
