12 Jun’19

Dynamics CRMUsing “startswith” Filter Query in MS Flow


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

  • Introduction to Microsoft Dynamics Commerce Tools

    19 October’ 2019

    As we know, Dynamics 365 Commerce is released in the preview version, So in this blog, we will have a quick explanation ...

    Read more
  • Error Handling Approaches for Integration

    16 October’ 2019

    Introduction: Handling Errors is a best practice in Integration when integrating to keep a track of the Errors that occu...

    Read more
  • Change in URLs for Business Central Tenants

    16 October’ 2019

    Change in base URLs for Business Central SaaS Tenants. I have noticed the Business Central links for Tenants have chan...

    Read more
  • Record Deletion Tool in Business Central

    16 October’ 2019

    Introduction: After a successful Go-Live in Business Central, we somehow need to delete a record from Backend. There is...

    Read more
  • Error “A reference to ‘xyz ‘ is required to compile this module” solution

    10 October’ 2019

    Many of the time while building project/solution we came across the “reference is required to compile this module ...

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