Integrating Microsoft Power Automate with Kintone

Article Number:040677

Microsoft Power Automate enables Kintone to exchange data with other web services. For example, you can set up an integration in such a way that a message is automatically posted in a chat app, such as Slack, each time a record is added on Kintone, or oppositely, a record is automatically added on Kintone each time a post that contains a specific keyword is created on the chat app.

This article explains integration between Microsoft Power Automate and Kintone, using Outlook and Gmail as examples.

Example setting: Sending an e-mail from Outlook each time a record is added on Kintone

  1. Create a Kintone app.
    Prepare the following fields, which will be used for entering information to be included in the e-mail.

    Field name Field type
    Date "Date" field
    Store "Drop-down" field
    Sales "Number" field

    Screenshot: The "Store Daily Report" app

  2. Sign in to Microsoft Power Automate and click My flows on the menu displayed on the left side.
    Microsoft Power Automate (Microsoft Power Automate site)
    In Microsoft Power Automate, integration workflows are called "flows". Screenshot: The screen that appears when you sign in to Microsoft Power Automate

  3. Click New flow and then Automated cloud flow.
    Screenshot: The screen to create a new flow

  4. Enter any name for the flow. Then, enter "Kintone" in the Search all triggers search box to search for a trigger.
    Screenshot: The screen to search triggers

  5. Click When a record is added to an app and then click Create. Screenshot: The screen for searching triggers

  6. Enter the Kintone domain you want to integrate with Microsoft Power Automate. Then, click Sign in.

    • A Kintone domain refers to the following part of the Kintone URL: subdomain name.kintone.com
      For example, if the URL is "https://example.kintone.com/k/#/portal", the domain is "example.kintone.com". Screenshot: The domain entry screen
  7. When you are prompted with a screen that asks whether you want to allow integration, click Allow. Screenshot: The dialog for allowing integration

  8. Enter the ID of the app that you want to use for the integration.

    • You can find the app ID in the URL of the app.
      For example, if the URL of the app is "https://example.kintone.com/k/23/", the app ID is "23". Screenshot: The App ID input field
  9. Click New step. Screenshot: The "New step" button

  10. On the screen to choose an operation, search for "Outlook" and click Send an email. Screenshot: The "Choose an operation" screen

  11. Set the information to be included in the e-mail.
    You can flexibly set the information in the e-mail, combining data of the Kintone app with specific strings. For example, you can set the information as follows:

    • To: E-mail address of a recipient
    • Subject: Today's sales ["Date" field value]
    • Body: Today's sales are as follows:
    • ["Store" field value] ["Sales" field value] Screenshot: The "Send an email" screen
  12. Click Save. Screenshot: The "Send an email" screen

You have successfully set up the flow.
An e-mail will be automatically sent from Outlook each time a record is added on the Kintone app.
The next section shows you how to create a flow that works in the opposite direction; that is, a flow that automatically adds a record on a Kintone app each time an e-mail is received.

Example setting: Adding a record on Kintone each time an e-mail is received on Gmail

  1. Create a Kintone app.
    Integration is not available for apps in guest spaces.
    Prepare the fields to be used for entering the subject and body of the received e-mail.

    Field name Field type
    Subject "Text" field
    Body "Text area" field

    Screenshot: The app form

  2. Sign in to Microsoft Power Automate and click My flows on the menu displayed on the left side.
    Microsoft Power Automate (Microsoft Power Automate site)
    In Microsoft Power Automate, integration workflows are called "flows". Screenshot: The screen that appears when you sign in to Microsoft Power Automate

  3. Click New flow and then Automated cloud flow. Screenshot: The screen for creating a new flow

  4. Enter any name for the flow. Then, enter "Gmail" in the Search all triggers search box to search for a trigger.
    Screenshot: The screen to search triggers

  5. Click When a new email arrives, and then click Create. Screenshot: The screen for searching triggers

  6. When you are prompted to connect to Gmail, click Sign in. Screenshot: Connecting to Gmail

  7. When a request to allow access to your Google account appears, click Allow. Screenshot: A request to access a Google account

  8. Click New step.
    Screenshot: The "New step" button

  9. On the screen to choose an operation, search for "Kintone" and select an action.
    In this example, we will select Add a record to an app. Screenshot: Selecting an action

  10. If the screen to sign in to Kintone appears, enter your domain and click Sign in.

    • A Kintone domain refers to the following part of the Kintone URL: subdomain name.kintone.com
      For example, if the URL is "https://example.kintone.com/k/#/portal", the domain is "example.kintone.com".
      Screenshot: Screen to enter a domain
  11. When you are prompted with a screen that asks whether you want to allow integration, click Allow. Screenshot: The dialog for allowing integration

  12. Set the information to be included in the record that will be added to the Kintone app.
    The information to be included in the record can be flexibly set using a combination of e-mail items and specific strings. Screenshot: The information to be included in a record

  13. Click Save. Screenshot: The "Save" button

You have successfully set up the flow. A record will be automatically added on Kintone every time an e-mail is received on Gmail. Screenshot: The Gmail screen             An arrow pointing down Screenshot: The "View" screen of an app In addition to the ones described above, there are many more useful integration workflows you can set up. Feel free to give them a try.