SafetyCulture
Last updated:

Power Automate: Email inspection reports with Outlook

Learn how to create a Power Automate flow to automatically email inspection reports with Outlook.

This flow utilizes Microsoft Outlook as the client to email inspection reports. This can be interchanged with other connectors, such as Power Automate's Mail connector and Gmail.

What you'll need

Inspection data that gets processed are based on the inspections, which the account that generated the API token has access to. If you're an administrator, you can provide yourself inspection access or assign yourself the "Override permissions: View all data" permission to have visibility over all inspections in your organization.

1. Recurrence

  1. Sign in to Power Automate.

  2. Click Create from the menu on the left-hand side and select Scheduled cloud flow.

  3. In the pop-up window, configure the following fields:

    • Flow name: Add a name for your flow so you can refer back to it easily.

    • Starting: Set the date and time you want the flow to start running.

    • Repeat every: Set the frequency to 1 Hour.

  4. Click Create to create the flow and its first step.

2. Get past time

  1. Click image below "Recurrence" and select Add an action.

  2. Search and select Get past time under the "Date Time" connector.

  3. Set the "Interval" to 1 and leave the "Time unit" as Hour.

3. Search modified inspections

  1. Click image below "Get past time" and select Add an action.

  2. Search and select Search modified inspections under the "SafetyCulture (iAuditor)" connector.

  3. If this is your first time using SafetyCulture on Power Automate, authenticate the connector by configuring the following fields, and then clicking Create New.

    • Connection Name: We recommend that you name the connection by the account username or email from which the API token is generated.

    • API token: Enter your API token in the format of "Bearer <token>". Make sure there is a space between "Bearer" and the API token.

  4. In the side panel, click Show all for advanced parameters and then configure the following fields:

    • Modified After: Click the field, then click image and select Past time from the list.

    • Filter by template (optional): If you only want to process inspections from a specific template, click the field to select the template from the dropdown menu, or select Enter custom value and input the template's unique identifier.

    • Archived (optional): Click the field and select true if you only want to process archived inspections, or select both for active and archived inspections.

    • Completed (optional): Click the field and select false if you only want to process incomplete inspections, or select both for complete and incomplete inspections.

    • Ownership (optional): Click the field and select me if you only want to process inspections that are owned by your account, or select other for inspections that are owned by other users in your organization.

    • Limit: Keep in mind that each flow run can only process up to 1,000 inspections. If your organization conducts more than 1,000 inspections every hour, you should narrow the frequency in "1. Recurrence" and "2. Get past time".

If you encounter any error related to "Data loss Prevention (DLP) policy" when creating the connection to SafetyCulture or any other apps, please contact your IT team to review Microsoft's DLP and unblock the connection.

4. Get a specific inspection

  1. Click image below "Search modified inspections" and select Add an action.

  2. Search and select Get a specific inspection under the "SafetyCulture (iAuditor)" connector.

  3. In the side panel, click the "Audit ID" field, then click image and select Inspection Audit ID from the list.

  4. This should add the action within a "For each" action.

5. Export an inspection report

  1. Click image below "Get a specific inspection" but within "For each" and select Add an action.

  2. Search and select Export an inspection report under the "SafetyCulture (iAuditor)" connector.

  3. In the side panel, click Show all for advanced parameters and configure the following fields:

    • Audit ID: Click the field, then click image and select Inspection Audit ID from the list.

    • Export Format: Select to export your inspection reports as either PDF or Word files.

    • Preference ID (optional): Click the field and select the report layout you want to apply. Keep in mind that only report layouts for all templates are available.

6. Delay

  1. Click image below "Export an inspection report" but within "For each" and select Add an action.

  2. Search and select Delay under the "Schedule" connector.

  3. In the side panel, set the "Count" to 1 and leave the "Unit" as Minute.

7. Check inspection export status

  1. Click image below "Delay" but within "For each and select Add an action.

  2. Search and select Check inspection export status under the "SafetyCulture (iAuditor)" connector.

  3. In the side panel, configure the following fields:

    • Audit ID: Click the field, then click image and select Inspection Audit ID from the list.

    • Export Task ID: Click the field, then click image and select Export Task ID from the list.

8. HTTP

  1. Click image below "Check inspection export status" but within "For each" and select Add an action.

  2. Search and select HTTP under the "HTTP" connector.

  3. In the side panel, configure the following fields:

    • URI: Click the field, then click image and select Export URL from the list.

    • Method: Click the field and select GET.

9. Send an email (V2)

  1. Click image below "HTTP" but within "For each" and select Add an action.

  2. Search and select Send an email (V2) under the "Office 365 Outlook" or "Outlook.com" connector.

  3. If this is your first time using Outlook on Power Automate, authenticate the connector by signing in to your Outlook account.

  4. In the side panel, click Show all for advanced parameters and then configure the following fields:

    • To: Click the field and specify the email recipients you want to email inspection reports to. Make sure you click "enter/return" on your keyboard for each email you add.

    • Subject: Click the field and specify the email subject. You can use data from preview items to name emails with inspection elements. For example, "[Template Name]: [Inspection Title] | [Score Percentage]".

    • Body: Click the field and specify the email body. Similar to the subject field, you can also use data from preview items to include inspection details. Check out the following email body as an example: An example of the Outlook action in a Power Automate flow.

    • Attachments: Click Plus iconAdd new item and configure the following fields:

      • Name - 1: Click the field, then click image and use items from the list to create a naming convention for inspection reports. Make sure to add ".pdf" or ".docx" at the end, depending on the report format you selected. For example, "<item>.pdf".

      • Content - 1: Click the field, then click image and select Body from the list.

  5. Click Save on the upper-right of the page to save the flow.

Test the flow (optional)

  1. Click Test on the upper-right of the page to begin testing the flow.

  2. Select Manually and click Test.

  3. Click Run flow.

  4. Click Done to monitor the test flow.

Please note that our customer support team can only provide limited help for single sign-on, user provisioning, and integrations via third-party platforms such as Power Automate, Power BI, and Zapier. If your organization is on the Enterprise Plan, please contact your customer success manager for assistance.

Need more help?
Email
Phone
Ask the community

Thank you for letting us know.

If you would like a reply from someone, please contact us atsupport@safetyculture.com.

In this article