9 Jun’19

Dynamics CRMUsing “contains” Filter Query in MS Flow

Introduction

This blog explains how to use “contains” filter query in MS Flow.

Use Case

Retrieve all the Accounts whose name contains ‘cloud’.

Steps to be Followed:

  1. We will use “Dynamics 365 – List records” Actions.
  2. Enter the Organization Name and entity.Filter Query: contains(name,’cloud’)
    • name is the logical name of the field which stores the account name.
    • ‘cloud’ is the value of account name by which we want to filter the retrieved account list.
    • Enter the above query in Filter Query:

  3. Run the flow to test.It will return all the account whose name contains “cloud’.
Written by

Vaishali Vyas

Software Engineer

Leave a Reply

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

Want to streamline your business processes?

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

Recent Articles

  • Open HTML in Model pop up in D365 CE

    3 December’ 2019

    Introduction When HTML is opened using JavaScript, it can either open in the same window or a different one. This natur...

    Read more
  • Suggest Vendor Payments feature in Payment Journal – NAV/ Business Central

    3 December’ 2019

    Introduction: In this blog, I will be attempting to highlight on Suggest Vendor Payment functionality in Payment Journa...

    Read more
  • How to resolve Error “Exception from HRESULT: 0xC0202009” While data export

    3 December’ 2019

    While  Exporting data using data entity in D365 FO sometimes the Data project fails to export data with error “Ex...

    Read more
  • How to create Tabular Model Project

    30 November’ 2019

    In this blog, we will learn how to create blank Tabular model project. Pre-requisite: Visual Studio with Business Intel...

    Read more
  • How to bring “AI” to Power BI

    28 November’ 2019

    The February 2019 release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencer...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close