How to Trigger Power Automate on SharePoint User Sign-In
Question details
The user wants to trigger a Power Automate flow specifically when a user signs in to SharePoint, but cannot find a native trigger for this event.
- Product
- Power Automate
- Device & OS
- not provided
- Scenario
- Automating workflows or tracking activity based on a user's authentication and entry into a SharePoint site.
- Observed behavior
- Power Automate only offers native triggers for file, folder, and list events, lacking an out-of-the-box option for detecting user sign-ins.
Verify your Microsoft 365 licensing (such as Business E3) in the admin center to ensure you have access to the necessary Power Apps features or premium Power Automate HTTP actions required for these workarounds.
Use a Scheduled Flow with the SharePoint REST API
Set up a flow that runs on a schedule to periodically check the SharePoint REST API for recent user activity.
Because Power Automate cannot detect real-time sign-ins natively, you can schedule a flow to run at specific intervals. This flow can query the SharePoint REST API to retrieve user information or recent site activity.
Keep in mind that this approach is a workaround. It will introduce a delay between the actual sign-in and the automation, and running frequent API queries will generate additional load.
Open Power Automate, create a new 'Scheduled cloud flow', and set an appropriate recurrence interval (e.g., every 15 minutes).
Add the 'Send an HTTP request to SharePoint' action to your workflow.
Set the Method to GET and input the appropriate REST API URI to query user profile activity or site usage data.
Add subsequent actions (like 'Condition' or 'Apply to each') to parse the JSON response and execute your required tasks if new activity is detected.
Initiate the Action via a Power Apps Form or Button
Create a custom Power Apps interface that requires user interaction upon opening SharePoint, simulating a login trigger.
Capture First Activity via a SharePoint List
Rely on standard list item creation or modification triggers to capture the user's ID during their first daily task.
Enhance Your Daily Productivity with WPS Office
While complex SharePoint automations require Microsoft 365, you can handle your daily document, spreadsheet, and presentation tasks seamlessly with WPS Office. It provides a lightweight, free alternative with high compatibility for standard Office files.
- 1. Download the Installer: Visit the official WPS Office website and click 'Free Download' to get the installer for your operating system.
- 2. Install WPS Office: Run the downloaded file and follow the straightforward on-screen instructions to complete the setup.
- 3. Open Your Documents: Launch WPS Office and open your existing Microsoft Office files to enjoy seamless format compatibility and a familiar interface.
Frequently Asked Questions
Why doesn't Power Automate have a SharePoint sign-in trigger?
Power Automate's standard SharePoint connectors are designed around data manipulation (files, lists, and records). User authentication and sign-in events are handled at the tenant level by Microsoft Entra ID (formerly Azure AD), not by SharePoint directly.
Can I use Microsoft Entra ID to trigger a flow on login?
Yes, but it requires premium configurations. Microsoft Entra ID tracks sign-in logs, which can be routed to Azure Monitor, Event Hubs, or Log Analytics. From there, you can trigger an Azure Logic App or Power Automate flow, though this requires administrative access and Azure subscriptions.
Where can I submit a feature request for a native sign-in trigger?
You can submit or vote for feature requests on the official Microsoft Power Automate Community Ideas forum. Microsoft product teams monitor these suggestions for future updates.
