Compliance Problems

How to Audit SharePoint, Power Apps, and Dynamics 365 Activity

Emma Brown Oct 14, 2026 868 views

Question details

The user needs to know how to track and audit user activities across Microsoft SharePoint, Power Apps, and Dynamics 365 for administrative and compliance purposes.

How to Audit SharePoint, Power Apps, and Dynamics 365 Activity

Product: Microsoft 365
Device & OS: not provided
Scenario: Tracking user actions and system events across multiple Microsoft enterprise applications.
Observed behavior: Needs to find the correct administrative center and configure settings to generate audit logs for specific activities in SharePoint, Power Apps, and Dynamics CRM.

Before you start

You must have tenant administrator privileges in your Microsoft 365 environment and ensure that auditing is turned on in the Microsoft Purview compliance portal before you can search the audit log.

Solution 1Recommended

Use Microsoft Purview for Power Apps and SharePoint Auditing

Use the centralized Microsoft Purview compliance portal to search for activities across standard Microsoft 365 services like Power Apps and SharePoint.

Microsoft Purview Audit allows administrators to search activity across many Microsoft 365 services, including SharePoint, Power BI, Microsoft Entra ID, Teams, and Power Apps.

Sign in to Microsoft Purview

Open a web browser and sign in to the Microsoft Purview portal using your tenant administrator account credentials.

Navigate to Audit Log Search

On the left-hand navigation pane, select 'Search', and then click on 'Audit log search'.

Configure Filters

Select the 'Power Apps activities' tab or the standard SharePoint activities to filter the services. Apply available filters such as specific users, date ranges, and activities.

Run the Search

Click 'Search' to generate the audit report for the selected parameters. You can export the results for further analysis.

Use Microsoft Purview for Power Apps and SharePoint Auditing

Log Visibility Delay: It may take up to 30 minutes, and sometimes up to 24 hours, after an event occurs for the corresponding audit log record to be returned in the search results.

Solution 2

Audit Activity using Dynamics 365 and Dataverse Tools

Dynamics 365 and Dataverse environments often require using their own built-in auditing features for granular data changes.

Free Microsoft Office alternative

Manage Your Compliance Reports with WPS Office

While auditing enterprise environments requires Microsoft Purview, you don't need expensive software to analyze the exported audit logs. WPS Office is a free, lightweight suite that seamlessly opens Microsoft Excel files, making it perfect for reviewing exported compliance data.

1. Download WPS Office: Download and install WPS Office on your computer or mobile device.
2. Export Audit Logs: Export your Microsoft Purview audit logs as a CSV or XLSX file.
3. Analyze Data: Open the exported file in WPS Spreadsheet to easily filter, sort, and analyze your compliance data.

Fully compatible with Microsoft Excel (.xlsx) formats for analyzing exported audit logs.Free and lightweight alternative to heavy enterprise Office subscriptions.Familiar user interface requires no learning curve.Cross-platform support for Windows, Mac, Linux, and mobile devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I see any audit logs in Microsoft Purview?

Audit logging is not enabled by default in all Microsoft 365 environments. A tenant administrator must manually turn on auditing in the Purview compliance portal before any user activities are recorded and searchable.

Can I audit specific CRM activities in SharePoint?

Yes, but it requires checking activities across both services. You need to search for SharePoint file activities related to CRM document management in Purview, as well as use Dynamics 365 specific audit settings for tracking CRM record changes.

Who has permission to search the Microsoft Purview audit log?

Only users assigned the 'View-Only Audit Logs' or 'Audit Logs' role in Exchange Online, which are typically granted to tenant administrators and compliance officers, have the necessary permissions to access and search the audit log.

How long are audit records retained in Microsoft 365?

By default, audit records are retained for 180 days for users with standard licenses. Organizations with premium compliance add-ons or specific retention policies can retain logs for up to one year or longer.

Microsoft Office Security Issues