Overview
With Mobaro's Power Automate connector you can export data on a schedule without writing code — for example, sending yesterday's Checklist Results to an Excel table every morning, or saving them as a CSV file in SharePoint.
This article builds a daily export flow. If you haven't used the connector before, start with Getting started with Mobaro's Power Automate connector to get an API key and connect.
At a glance |
|
Who can do this | Anyone with a Premium Power Automate license and a Mobaro API key. Users with Organization › Administrate create API keys |
Where | Power Automate › Create › Scheduled cloud flow. API keys: Configuration › API › API Keys |
Works on | Public API, through Power Automate |
Availability | API access is enabled per organization by Mobaro — ask your CSM |
🛑 Critical: Microsoft classifies the Mobaro connector as Premium, so everyone who builds or runs a flow with it needs a Premium Power Automate license. Mobaro doesn't control this classification.
Build a daily export flow
1. Create a scheduled flow
Go to Power Automate, click Create and choose Scheduled cloud flow.
2. Set the schedule
Name the flow, set the start time and choose how often it repeats — usually once a day.
3. Add a Mobaro list action
Add a step, search for Mobaro and choose the list action for the data you want: List all results, List all assignments or List all timesheet entries. The first time, Power Automate asks you to connect with your Mobaro API key.
4. Filter to one day
Set the date filters to the period you want, such as the previous day:
List all results:
AnsweredAfterandAnsweredBefore. You can also filter byLocations,LocationGroups,Checklists,Schedules,AssetsorUsers.List all assignments:
CreatedAfterandCreatedBefore, orUpdatedAfterandUpdatedBefore, plusStatusandLocations.List all timesheet entries:
StartedAfterandStartedBefore, plusUsers.
5. Page through the data
Each call returns one page. List all results returns up to 20 per call; assignments and timesheet entries up to 128. The response includes total, so use a Do until loop that increases Offset by the page size until you have them all.
⚠️ Heads-up: Without paging, a daily export silently stops at the first page — 20 Results — and the rest of the day is missing from your file.
6. Shape the data (optional)
Add a Filter array or Select step to keep only the fields you need. For timesheet entries, filter out entries where isDeleted is true: the API still returns entries that were deleted in Mobaro.
7. Send the data to its destination
Excel Online: Add a row into a table. The workbook must already contain a table with column headers.
SharePoint or OneDrive: Create CSV table, then Create file to save a .csv file.
Email: Send an email (V2), with a Create CSV table step for a table in the body or an attachment.
Best practices
Export a closed period, such as yesterday from 00:00 to 00:00 today, so runs don't overlap or leave gaps.
Use a Read-only API key, and give each flow its own key so you can delete one without breaking others.
Stay within the API's rate limit of 10 requests per second per key: add a short delay inside paging loops.
Run the flow manually once and check the row count against Results in the Backend before relying on it.
Frequently asked questions
Can checklist results be sent to Excel or email automatically every day?
Yes — set up the flow in this article. If you only need a report emailed each time a Checklist is completed, use a Result Report notification rule instead; it needs no Power Automate. See How to set up a Result Report.
Can I export timesheet entries every day?
Yes. Use List all timesheet entries with StartedAfter and StartedBefore, and leave out entries where isDeleted is true. For a one-off download, see Reporting and exporting Timesheets.
Why does my flow only return 20 results?
List all results returns at most 20 Results per call. Loop through the pages by increasing Offset by 20 until you've fetched the number in the response's total.
Can I limit the export to certain locations or checklists?
Yes. List all results has Locations, LocationGroups, Checklists, Schedules, Assets and Users filters, which take Mobaro IDs. Get the IDs with List all locations or List all checklists.
Where can I find documentation for the Mobaro connector's actions?
Each action matches the Mobaro API operation of the same name. See Getting started with Mobaro's Power Automate connector and the Mobaro API parameter reference.