Weekly activity reporting

JoshuaConsunet you won't be able to get the details of documents that have been deleted because they have been....deleted! But you can get the Created and Modified details - we send a list of the changes every month on one of our sites to a group of staff. If you want to be specific about which documents were created and which were modified then the flow given earlier will need to be more complex to check if the creation and modified dates are the same.

Our flow looks at the same spreadsheet on the 1st of each month in OneDrive and initially deletes the current rows from the table. It sets the Past Time control to look for 1 month ago then loops through each of the 10 Site Pages and document libraries and gets those modified greater than or equal to the Past Time date and adds them into the table in the spreadsheet. The result looks like this (I could improve it by changing the format of the Modified date but I haven't got round to it):

Rob
Los Gallardos
Microsoft Power Automate Community Super User