ActivityInfo (Preview)

ActivityInfo is a simple and intuitive relational database platform designed for the social sector, and widely used by NGOs, the UN and governments. ActivityInfo makes it easy to define data collection forms, relate them to each other, clean and correct data, and visualize results in real time.

This connector is available in the following products and regions:

ActivityInfo is an information management software for the social sector that includes a no-code relational database builder, integrated analysis tools, and advanced user-management capabilities.

The ActivityInfo connector allows users to create automations in their ActivityInfo databases from PowerAutomate. This will allow PowerAutomate users to create workflows that perform an action in PowerAutomate (e.g. send an email) in response to an event triggered in their ActivityInfo database (e.g. when a caseworker adds a new record)

Prerequisites

• A valid Microsoft PowerAutomate subscription.
• A valid ActivityInfo account with access to an active database.
• An ActivityIfo database you own or have "Manage Automations" permission granted.
• An API token from ActivityInfo with Read and Write scope.

How to get credentials

• Login to ActivityInfo.
• Visit your account settings and then select API Token.
• Create an API token with Read and Write scope for use in your PowerAutomate connector.

Getting started with your connector

• Sign in to your PowerAutomate account.
• Create a new flow and search for ActivityInfo when prompted for a trigger.
• Specify your API token to create a new connection or use an existing one.
• Select a trigger type: “on record added”, “on record edited”, or “on record deleted”.
• Select a form or subform from your list of forms in your ActivityInfo databases.
• After setting up your ActivityInfo connector as your trigger, build your workflow using action(s) in PowerAutomate.
• Login to ActivityInfo and add, edit or delete a record in your form to test your flow.
• Noteworthy: you can find all your automations (including those created in PowerAutomate) in your ActivityInfo database settings.

Known Issues and Limitations

• Filters can only be specified in ActivityInfo and not in PowerAutomate.
• To use a filter, you will have to update the automation definition in ActivityInfo.
• Any changes made to an automation created in PowerAutomate will not reflect in PowerAutomate.
• Any edits made in PowerAutomate will result in loss of any edits previously made in ActivityInfo for the automation.

Common errors and remedies

Here are some issues you could face while using the connector:

• Error 400: Appears when you make a bad request, it is probably occurring because there is a field type in your form that's not supported by ActivityIfo's PowerAutomate APIs.
• Error 401: Appears when an API token is invalid, revoked or unauthorised.
• Error 403: Appears when you do not (or no longer) have access to ActivityInfo or resources within it.

If you have any questions/issues contact your ActivityInfo database administrator or for general questions about ActivityInfo, feel free to contact us.

Creating a connection

The connector supports the following authentication types:

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Throttling Limits

Triggers

When a record is added

When a record is deleted

When a record is edited