12 Jun’19

Dynamics CRM

Using “startswith” Filter Query in MS Flow

Introduction

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

Use Case

Using MS Flows to retrieve the bunch of students who’s mobile numbers begin with +91 and send them a text (using Twilio connector) regarding the Top Indian Universities. The “starts with” filter query in MS Flows allows to easily achieve this functionality.

Steps to be Followed:

  1. We will use “Dynamics 365 – List records” Actions.
  2. Enter the Organization Name and select the entity. Filter Query: startswith(new_phonenumber,’+91′)
    • new_phonenumber” is the logical name of the field which stores the phone number of students.
    • ‘+91’ is the value of phone number by which we want to filter the retrieved student list.
    • Enter the above query in Filter Query:
  3. Run the flow to test.It will return all the students whose phone number starts with “+91”
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

  • Integrate Dynamics 365 for Customer Engagement Apps with Microsoft Teams

    18 June’ 2019

    Before getting into details, firstly I would like to talk about Microsoft Teams. If you’re familiar with MS Teams, you...

    Read more
  • Applying Default / Mandatory Dimension in NAV / Business Central

    17 June’ 2019

    Introduction: In this blog, I aim to provide how to set Mandatory Dimensions on Items, Customers, Vendors, and G/L Accou...

    Read more
  • Automatically adding dimensions from Shortcut Dimension from Excel Import in Microsoft Dynamics NAV / Business Central

    17 June’ 2019

    Problem Statement: I have a requirement where the contents of the General Journals are to export to Excel and also can c...

    Read more
  • Using “startswith” Filter Query in MS Flow

    12 June’ 2019

    Introduction This blog explains how to use “startswith” filter query in MS Flow. Use Case Using MS Flows to retrieve...

    Read more
  • Print pro-forma invoice in Dynamics 365 Finance and Operations

    11 June’ 2019

    In this article I am going to demonstrate how to view/print  pro-forma invoice. A pro forma invoice is an invoice that ...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.

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