9 Jun’17

BIComparing Integration Platforms: Microsoft Flow vs Zapier

In this article, we are going to compare features of Microsoft Flow and Zapier.

Real Time Integration:

Microsoft Flow:

Flow gets automatically triggered based on create/update/delete record defined in the workflow.

Note: Triggers for Create, Delete and Update are available

Zapier:

Zap gets automatically triggered based on create record defined in the workflow.

Note: Trigger for Create is available

Scheduled Integration:

Microsoft Flow:

Flow can be scheduled by day, hour, minute, seconds. Recurrence action is used for the same.

Zapier:

Zap cannot be scheduled. It can only be triggered on Creation of new record.

Triggers:

Microsoft Flow:

Triggers can be specified for any entity.

Zapier:

Triggers can be specified for limited entities.

For example: For Dynamics CRM, the trigger can defined only for Contact, Opportunity, Lead and Account.

Lookup Action:

Microsoft Flow:

  1. Records can be looked up using GUID / Unique Identifier of the record.
  2. We can look up to any entity.

Zapier:

  1. Lookup record i.e. Search in Zap is different for different Connections.
  2. Only few Entities is provisioned for Search
  3. Criteria for Search can be based on all fields or one field based on Connectors (Explained below with example)
  4. Search value can dynamic i.e. values can be retrieved through previous steps.

For Example:

  • Search for Salesforce can be based on any field

  • For Dynamics CRM, condition for Search for Contact is based only on email address.

Conditional Workflow:

Microsoft Flow:

Various flow control can be setup in Flow like if-else, switch-case, do-until, etc.

Zapier:

Logical conditions setup is currently not available in Zap.

Filters:

Microsoft Flow:

Source records cannot be filtered.

Zapier:

Filter feature not available.

Data Formatting:

Microsoft Flow:

Data fetched from Source cannot be formatted before sending to target. Flow supports simple one-to-one mappings.

Zapier:

Data fetched from Source cannot be formatted before sending to target. Zapier supports simple one-to-one mappings.

Execution History:

Microsoft Flow:

Errors can be monitored in Activity section in Flow. Errors cannot be handled inside a Flow.

Zapier:

Errors can be monitored in Task History section in Zapier. Errors cannot be handled inside a Zap

Debug:

Microsoft Flow:

Debug feature is not available for a Flow. Though, after execution you can get output of each step

Zapier:

Debug feature is not available for a Zap. Though, after execution you can get input and output of each step.

Conclusion:

Summary for the Integration Tools: Microsoft Flow vs Zapier.

Features Microsoft Flow Zapier
Real-Time Integration Yes Yes
Scheduled Integration Yes No
Execution History Yes Yes
Error Handling No No
Debug No
Get output of each step after execution
No

Get output of each step after execution

Triggers Create/Update/Delete Only for Create
Lookup Action Immature Mature than Microsoft Flow
Filters No No
Conditional Workflow Yes No
Data Formatting No No

 

Written by

Anjali Hemmadi

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more