Using Dynamics 365 in an Automated Workflow

You can use your Dynamics 365 data as part of a workflow in Microsoft Flow.


You must have a valid account with Dynamics 365 and with Flow.

To add Dynamics 365 as a data source in Flow

  1. In your browser, navigate to, and then sign in.
  2. Choose My Flows from the ribbon at the top of the page.
  3. In the My Flows window, choose the Create from blank option.
  4. From the list of available triggers, select one of the two Dynamics 365 triggers available: When a record is created, or When a record is modified.
  5. Flow will display a connection page that prompts you for the information that is required to connect to your Dynamics 365 data. To connect, you must specify a name for the connection, an OData URL, username, password, and company name.

    For the OData URL, you can copy the OData V4 URL of any of the web services that are listed in the Web Services page in Dynamics 365, such as

    For the Company Name, use the name that is shown in the Name field in the Company Information window in Dynamics 365. If your Dynamics 365 contains multiple companies, choose the relevant company name from the list in the Companies window. In both cases, make sure that the name that you specify in the PowerApps wizard matches exactly the text shown in Dynamics 365, such as My Company.

    For the username and password, use the name and web service access key that are specified for your account in the Users window in Dynamics 365. For example, your username is ADMIN, and the web service access key that serves as your password is EgzeUFQ9Uv0o5O0lUMyqCzo1ueUW9yRF3SsLU=. For more information, see How to: Manage Users and Permissions.

  6. Choose the Create button at the bottom of the page to continue.

    Flow will show a list of tables that are available from Dynamics 365. These tables, or end points, represent all the web services that you have published from Dynamics 365.

    Alternatively, create a new web service URL in Dynamics 365 by using the Create Data Set action in the Web Services page, using the Set Up Reporting Assisted Setup guide, or by choosing the Edit in Excel action in any lists.

  7. Choose the data that you want to use for in Flow.

At this point, you have successfully connected to your Dynamics 365 data and are ready to begin building your flow. For more information, see the Flow documentation.

See Also

Welcome to Dynamics 365 for Finance and Operations, Business edition
Importing Business Data from Other Finance Systems
How to: Manage Users and Permissions
Setting Up Dynamics 365