This guide will take you through the process of using the iAuditor connector available in Microsoft Flow, which enables you to automatically update SharePoint lists with Inspection data.
- Premium iAuditor User Account
- iAuditor API Token
- Office 365 User Account
- Access to the Premium version of Microsoft Flow
Begin by creating a new blank flow and then add the Schedule – Recurrence trigger. We’re going to configure the flow to check your iAuditor data for modified audits each hour.
Go ahead and set up the trigger so that the Interval is 1 and the Frequency is Hour.
The Get past time action is also needed for this. Add it to your flow and configure it to match the settings for the trigger.
A maximum of 1000 audits can be processed during each interval. You will need to configure a smaller interval if your organisation is completing more than this number of audits hourly.
The next step is to add the Search modified audits action listed under iAuditor and set the Modified after field to use Past time from the available dynamic content.
When the authentication prompt appears, enter “iAuditor” as your “Connection Name”.
Within the “API Key” field, type “Bearer” followed by a whitespace and your API token. Your connection settings should be as below:
Next, add the Get a specific audit action and select Audits Audit ID from the Dynamic Content on the right to add it to the Audit ID field. This will automatically become nested within an Apply to each loop.
Within the Apply to each loop after the Get a specific audit Action, add the SharePoint action Create item. Enter your SharePoint Site Address, select your List Name and then use the Audit data from the Dynamic Content on the right to select the information that will appear in the List Item in the Title field.
Hit Save and now any new inspections will populate a new List item within your selected list.