Looking to keep copies of inspection data in SharePoint, or even update a project automatically? Try out this quick integration through MS Flow to automate your manual tasks, and reduce the probability something gets lost in the shuffle.

This guide shows you how to automatically update SharePoint lists with Inspection data, using the iAuditor connector available in Microsoft Flow.

Requirements

  • Premium iAuditor User Account
  • iAuditor API Token
  • Office 365 User Account
  • Access to the Premium version of Microsoft Flow
IMPORTANT NOTE

A maximum of 1000 inspections (audits) can be processed during each interval. You will need to configure a smaller interval if your organization is completing more than this number of inspections hourly.

Steps for setup in MS Flow

In this example, we will configure the flow to check your iAuditor data for modified inspections each hour. You can customize this to what you need.

Step 1:

  1. Create a new blank “Automated Flow” and name it
  2. Skip “Choose your Flow’s trigger”
  3. Search and select the “Recurrence” trigger
  4. Set up the Schedule so that “Interval” = 1 and “Frequency” = Hour
  5. Proceed with “+ New step”

Step 2:

  1. Search and select the “Get past time” action
  2. Configure it to match the “Recurrence” of “Interval” = 1 and “Frequency” = Hour
  3. Proceed with “+ New step”

Step 3:

  1. Search and select the “Search modified audits – iAuditor” action
  2. Set the “Modified after” field to use Past time from the available dynamic content.
IMPORTANT NOTE

If this is your first time using iAuditor on MS Flow, you will be prompted to authenticate the connection.

Authentication:

  1. When the authentication prompt appears, enter “iAuditor” as your “Connection Name”
  2. Within the “API Key” field, type “Bearer” followed by a whitespace, then your API token
  3. Your connection setting should be as below:

Step 4:

  1. Search and select the “Get a specific audit – iAuditor” action
  2. Click the Audit ID field and select “Audits Audit ID” from the Dynamic Content on the right
  3. This will automatically become nested within an “Apply to each” loop
  4. Click the “Get a specific audit (Preview)” step and select “Audits Audit ID” from the Dynamic Content on the right again
  5. Now “Add an action” with in the Apply to each loop

Step 5:

  1. Search and select the “Create item – SharePoint” action
  2. Enter your SharePoint “Site Address” and select your “List Name”
  3. Use the Audit data from the Dynamic Content on the right to select the information that will populate in the List Item in the Title field.
  4. Hit “Save” and now any new inspections will populate a new List item within your selected list.

Final Result

Was this article helpful?

We love your feedback. Please tell us what you think.


Yes No
Care to share a bit more so we can continue to make improvements for you? Care to share a bit more so we can make this article even better for you? Thanks for your feedback!