Audit Log Report Generation Through Power Automate

Like (0) Share

Report

Posted on 12 Jul 2022 14:23:26 by Community Power Pla...

Hello Everyone,

I am new to this community as well as to the technology.

As per our project requirements, I am looking for the way to Create Power Automate Flow that would generate excel file in a particular folder weekly or monthly for all the activities that a user do in a site like creation ,updating, deletion etc.

Also Admin can generate excel audit report according to his/her requirements, For that I also need to create Custom PowerApps Form.

I am following this link http://www.sharepointsamples.com/schedule-sharepoint-site-audit-report-using-microsoft-power-automate-o365-management-activity-api/ ,but in this an email is sent at the end with CSV table but I need to generate excel report.

Please help and suggest to achieve my task.

#powerautomate

All responses (2)

Answers (1)

Community Power Pla... on 12 Jul 2022 at 14:45:01

Like (0)

Report

Re: Audit Log Report Generation Through Power Automate

@ScottShearer Thanks for the reply.
Could you share any link which has all the steps to achieve this ?
And I don't want to email the report I want to save it in particular folder in that site.
And is there any way in PowerApps to create Custom form to achieve this?
As our client need flexibility to generate Audit Report as per his requirement .He needs both through Power Automate(automated) and PowerApps(custom).
Verified answer

ScottShearer 25,223 Most Valuable Professional on 12 Jul 2022 at 14:37:37

Like (1)

Report
Re: Audit Log Report Generation Through Power Automate

@Anonymous

Instead of creating the HTML table, consider this:

Have an excel file that contains a table or tables with all the columns that you need

When you need the report, create a copy of the Excel file via Flow

Use the Add a rows to a table (Excel online) action to add the data to the Excel table

Save and email the new file