Using Fetch Xml query in Power Automate Flow.

Hello Guys,

In our previous blog we have seen how to use expand query in Power Automate Flow. Today we are going to see how to use fetch xml query using MS Flow.



Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends.

There are some scenarios where we need to perform Joins which we were doing in SQL for joining multiple table to retrieve data from various tables. Here in D365 we are having the concept of lookup field which is nothing but the separate entity. This entity is also having some additional columns.

As we have Contact table which is having Company(Account), Country(Country) lookup. These lookups are also a separate table. Also Country table is having Region lookup. Consider a scenario where we are retrieving contact list and we also want some additional fields from these various tables then we need to use fetch xml query in Power Automate Flow.

Let's see how to retrieve and access these columns using fetch xml query. First of all we will be creating a manual flow. for time being I have already created one manual flow as shown below:



Now we will be adding a new step in this flow which will be List and it will retrieve all active contacts along with additional fields.



We have used below fetch xml query.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

  <entity name="contact">

    <attribute name="telephone1" />

    <attribute name="emailaddress1" />

    <attribute name="contactid" />

    <attribute name="lastname" />

    <attribute name="jobtitle" />

    <attribute name="firstname" />

    <attribute name="blg_country" />

    <attribute name="parentcustomerid" />

    <order attribute="emailaddress1" descending="false" />

    <filter type="and">

      <condition attribute="statecode" operator="eq" value="0" />

    </filter>

    <link-entity name="blg_country" from="blg_countryid" to="blg_country" visible="false" link-type="outer" alias="country">

    <attribute name="blg_regionid" />

<attribute name="blg_name" />

<link-entity name="blg_region" from="blg_regionid" to="blg_regionid" visible="false" link-type="outer" alias="region">

      <attribute name="blg_name" />

    </link-entity>

    </link-entity>

    <link-entity name="account" from="accountid" to="parentcustomerid" visible="false"  link-type="outer" alias="account">

      <attribute name="paymenttermscode" />

    </link-entity>

  </entity>

</fetch>



Here you can see that paymenttermscode is additional field which is available on Account lookup. Now we will select the data from the previous step.



We have used below formula to access additional fields.

item()?['account.paymenttermscode@OData.Community.Display.V1.FormattedValue']

item()?['_parentcustomerid_value@OData.Community.Display.V1.FormattedValue']

item()?['country.blg_name']

item()?['country.blg_regionid@OData.Community.Display.V1.FormattedValue']

So we are done. Now we will run the flow and check whether we are able to access additional fields or not.


















[
  {
    "FirstName": "Calvin",
    "LastName": "Conte",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-4773",
    "PaymentTerm": "Net 30",
    "CompanyName": "Contoso Electronics",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tommie",
    "LastName": "Bowers",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-9590",
    "PaymentTerm": "Net 30",
    "CompanyName": "Contoso Instrumentation",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Bobbi",
    "LastName": "Christian",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-4255",
    "PaymentTerm": "Net 30",
    "CompanyName": "Contoso Assembly",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Maynard",
    "LastName": "Lafferty",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-4077",
    "PaymentTerm": "Net 30",
    "CompanyName": "Trey Research",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Freida",
    "LastName": "Farley",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-9480",
    "PaymentTerm": "Net 30",
    "CompanyName": "Trey Research Engineering",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Jodi",
    "LastName": "Ferrell",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-9441",
    "PaymentTerm": "Net 30",
    "CompanyName": "Trey Research Fabrication",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Ora",
    "LastName": "Rodriguez",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-7041",
    "PaymentTerm": "Net 30",
    "CompanyName": "Trey Research Electronics",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Alexis",
    "LastName": "Fry",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-0872",
    "PaymentTerm": "Net 30",
    "CompanyName": "Trey Research Instrumentation",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Andrew",
    "LastName": "Book",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-2567",
    "PaymentTerm": "Net 30",
    "CompanyName": "Trey Research Assembly",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Darrell",
    "LastName": "Bromley",
    "JobTitle": null,
    "Email": null,
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Mack",
    "LastName": "Fannin",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-8595",
    "PaymentTerm": "Net 30",
    "CompanyName": "Litware, Inc.",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Eloise",
    "LastName": "Steele",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-0554",
    "PaymentTerm": "Net 30",
    "CompanyName": "Litware Engineering",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Terrie",
    "LastName": "Patrick",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-9425",
    "PaymentTerm": "Net 30",
    "CompanyName": "Litware Fabrication",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Rudolph",
    "LastName": "Schiller",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-2062",
    "PaymentTerm": "Net 30",
    "CompanyName": "Litware Electronics",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Jayne",
    "LastName": "Carr",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-9602",
    "PaymentTerm": "Net 30",
    "CompanyName": "Litware Instrumentation",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Catalina",
    "LastName": "Weeks",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-9199",
    "PaymentTerm": "Net 30",
    "CompanyName": "Litware Assembly",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Carol",
    "LastName": "McLaughlin",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-8641",
    "PaymentTerm": "Net 30",
    "CompanyName": "Litware Integration",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Heriberto",
    "LastName": "Nathan",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-9330",
    "PaymentTerm": "Net 30",
    "CompanyName": "Northwind Traders",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Everett",
    "LastName": "Fielder",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-1596",
    "PaymentTerm": "Net 30",
    "CompanyName": "Northwind Traders Engineering",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Claudia",
    "LastName": "Ballard",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-2881",
    "PaymentTerm": "Net 30",
    "CompanyName": "Northwind Traders Fabrication",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Margarita",
    "LastName": "Russo",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-5371",
    "PaymentTerm": "Net 30",
    "CompanyName": "Northwind Traders Electronics",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Randy",
    "LastName": "Thiel",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-0420",
    "PaymentTerm": "Net 30",
    "CompanyName": "Northwind Traders Instrumentation",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Max",
    "LastName": "McLean",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-3323",
    "PaymentTerm": "Net 30",
    "CompanyName": "Northwind Traders Assembly",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Clay",
    "LastName": "Clemente",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-4831",
    "PaymentTerm": "Net 30",
    "CompanyName": "Northwind Traders Integration",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Bette",
    "LastName": "Goodman",
    "JobTitle": null,
    "Email": null,
    "Phone": "425-555-9533",
    "PaymentTerm": "Net 30",
    "CompanyName": "Southridge Video",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Trudy",
    "LastName": "Dickson",
    "JobTitle": null,
    "Email": null,
    "Phone": "206-555-5817",
    "PaymentTerm": "Net 30",
    "CompanyName": "Southridge Video Engineering",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Amie",
    "LastName": "Gonzales",
    "JobTitle": null,
    "Email": null,
    "Phone": "248-555-0131",
    "PaymentTerm": "Net 30",
    "CompanyName": "Southridge Video Electronics",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Nanette",
    "LastName": "Cervantes",
    "JobTitle": null,
    "Email": null,
    "Phone": "415-555-0174",
    "PaymentTerm": "Net 30",
    "CompanyName": "Southridge Video Integration",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Angelo",
    "LastName": "Razo",
    "JobTitle": null,
    "Email": null,
    "Phone": "503-555-0164",
    "PaymentTerm": "Net 30",
    "CompanyName": "Tailspin Toys Fabrication",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Susanne",
    "LastName": "Holcomb",
    "JobTitle": null,
    "Email": null,
    "Phone": "301-555-0127",
    "PaymentTerm": "Net 30",
    "CompanyName": "Tailspin Toys Electronics",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Mallory",
    "LastName": "Rosario",
    "JobTitle": "Operations Director",
    "Email": null,
    "Phone": "425-555-6792",
    "PaymentTerm": "Net 30",
    "CompanyName": "The Phone Company Engineering",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Jennifer",
    "LastName": "Wilkins",
    "JobTitle": null,
    "Email": null,
    "Phone": null,
    "PaymentTerm": "Net 30",
    "CompanyName": "Contoso Instrumentation",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Abraham",
    "LastName": "McCormick",
    "JobTitle": null,
    "Email": "abraham_mccormick@fabrikam.com",
    "Phone": "425-555-7700",
    "PaymentTerm": null,
    "CompanyName": "Fabrikam Robotics",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "System",
    "LastName": "Administrator",
    "JobTitle": null,
    "Email": "admin@contoso.com",
    "Phone": "425-555-5555",
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Adrian",
    "LastName": "Dumitrascu",
    "JobTitle": "Purchasing Manager",
    "Email": "Adrian@adventure-works.com",
    "Phone": "768-555-0156",
    "PaymentTerm": "Net 30",
    "CompanyName": "Adventure Works",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Adrienne",
    "LastName": "McMillan",
    "JobTitle": null,
    "Email": "adrienne_mcmillan@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Alex",
    "LastName": "Simmons",
    "JobTitle": null,
    "Email": "alexs@graphicdesigninstitute.com",
    "Phone": "1-555-555-5554",
    "PaymentTerm": null,
    "CompanyName": "Graphic Design Institute",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Alex",
    "LastName": "Wu",
    "JobTitle": "Purchasing Manager",
    "Email": "alexw@northwindtraders.com",
    "Phone": "555-123-4879",
    "PaymentTerm": null,
    "CompanyName": "Northwind Traders",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Allison",
    "LastName": "Dickson",
    "JobTitle": null,
    "Email": "allison_dickson@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Andrew",
    "LastName": "Dixon",
    "JobTitle": "Owner",
    "Email": "andrewr@litware.com",
    "Phone": "555-789-8856",
    "PaymentTerm": null,
    "CompanyName": "Litware",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Ashley",
    "LastName": "Chinn",
    "JobTitle": null,
    "Email": "ashley_chinn@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Bernadette",
    "LastName": "Foley",
    "JobTitle": null,
    "Email": "bernadette_foley@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Bob",
    "LastName": "Kozak",
    "JobTitle": null,
    "Email": "bob_kozak@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Brady",
    "LastName": "Hannon",
    "JobTitle": null,
    "Email": "brady_hannon@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Brian",
    "LastName": "LaMee",
    "JobTitle": "Purchasing Manager",
    "Email": "brian@blueyonderairlines.com",
    "Phone": "555-0135",
    "PaymentTerm": "Net 30",
    "CompanyName": "Blue Yonder Airlines",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Bruno",
    "LastName": "Torres",
    "JobTitle": null,
    "Email": "brunot@lucernepublishing.com",
    "Phone": "407-967-2218",
    "PaymentTerm": null,
    "CompanyName": "Lucerne Publishing",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Can",
    "LastName": "Comertoglu",
    "JobTitle": null,
    "Email": "camco@northwindtraders.com",
    "Phone": "012-156-8755",
    "PaymentTerm": null,
    "CompanyName": "Northwind Traders",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Cat",
    "LastName": "Francis",
    "JobTitle": "Purchasing Manager",
    "Email": "Cat@cohowinery.com",
    "Phone": "123-879-9879",
    "PaymentTerm": null,
    "CompanyName": "Coho Winery",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Cathan",
    "LastName": "Cook",
    "JobTitle": "Purchasing Assistant",
    "Email": "Cathan@alpineskihouse.com",
    "Phone": "178-854-4566",
    "PaymentTerm": "Net 30",
    "CompanyName": "Alpine Ski House",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Cheri",
    "LastName": "Castaneda",
    "JobTitle": null,
    "Email": "cheri_castaneda@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Chris",
    "LastName": "Gallagher",
    "JobTitle": "IT Manager",
    "Email": "chrisg@cpandl.com",
    "Phone": "789-741-8539",
    "PaymentTerm": "2% 10, Net 30",
    "CompanyName": "City Power & Light",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Christal",
    "LastName": "Robles",
    "JobTitle": null,
    "Email": "christal_robles@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Christie",
    "LastName": "Dawson",
    "JobTitle": null,
    "Email": "christie_dawson@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Clarence",
    "LastName": "Desimone",
    "JobTitle": null,
    "Email": "clarence_desimone@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Portal",
    "LastName": "Customer",
    "JobTitle": null,
    "Email": "customer@contoso.com",
    "Phone": "425-555-5555",
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Daniel",
    "LastName": "Escapa",
    "JobTitle": "Board Member",
    "Email": "daniel@fourthcoffee.com",
    "Phone": "789-741-8545",
    "PaymentTerm": "Net 30",
    "CompanyName": "Fourth Coffee",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Darren",
    "LastName": "Parker",
    "JobTitle": "Purchasing Manager",
    "Email": "darren.parker@woodgrovebank.com",
    "Phone": "408-875-4573",
    "PaymentTerm": "Net 30",
    "CompanyName": "Woodgrove Bank",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "David",
    "LastName": "Probst",
    "JobTitle": null,
    "Email": "davidp@cpandl.com",
    "Phone": "456-698-4561",
    "PaymentTerm": "2% 10, Net 30",
    "CompanyName": "City Power & Light",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Davis",
    "LastName": "Flournoy",
    "JobTitle": null,
    "Email": "davis_flournoy@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Dawn",
    "LastName": "Phelps",
    "JobTitle": null,
    "Email": "dawn_phelps@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Dianna",
    "LastName": "Woodward",
    "JobTitle": null,
    "Email": "dianna_woodward@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Dick",
    "LastName": "Cowley",
    "JobTitle": null,
    "Email": "dick_cowley@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Edgar",
    "LastName": "Dominquez",
    "JobTitle": null,
    "Email": "edgar_dominquez@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Efrain",
    "LastName": "Schreiner",
    "JobTitle": null,
    "Email": "efrain_schreiner@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Eric",
    "LastName": "Stanly",
    "JobTitle": "Software Developer",
    "Email": "eric.23@gmail.com",
    "Phone": "8909765434",
    "PaymentTerm": "Net 30",
    "CompanyName": "Adventure Works",
    "Country": "Germany",
    "Region": "Europe"
  },
  {
    "FirstName": "Ravish",
    "LastName": "Gupta",
    "JobTitle": "Tech Consultant",
    "Email": "ravish22.gupta@yahoo.in",
    "Phone": "9667886634",
    "PaymentTerm": "Net 60",
    "CompanyName": "A. Datum",
    "Country": "India",
    "Region": "Asia"
  },
  {
    "FirstName": "Reba",
    "LastName": "Potts",
    "JobTitle": null,
    "Email": "reba_potts@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Reed",
    "LastName": "Hermann",
    "JobTitle": null,
    "Email": "reed_hermann@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Reggie",
    "LastName": "Amaral",
    "JobTitle": null,
    "Email": "reggie_amaral@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Reina",
    "LastName": "Cabatana",
    "JobTitle": null,
    "Email": "reina_cabatana@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Ricardo",
    "LastName": "Seely",
    "JobTitle": null,
    "Email": "ricardo_seely@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Rickie",
    "LastName": "Seely",
    "JobTitle": null,
    "Email": "rickie_seely@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Robert",
    "LastName": "Lyon",
    "JobTitle": null,
    "Email": "rlyon@fabrikam.com",
    "Phone": "123-879-9941",
    "PaymentTerm": "Net 60",
    "CompanyName": "Fabrikam, Inc.",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Robin",
    "LastName": "Counts",
    "JobTitle": null,
    "Email": "robinc@graphicdesigninstitute.com",
    "Phone": "123-879-9943",
    "PaymentTerm": null,
    "CompanyName": "Graphic Design Institute",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Robin",
    "LastName": "Wood",
    "JobTitle": null,
    "Email": "robinw@litware.com",
    "Phone": "407-967-2237",
    "PaymentTerm": null,
    "CompanyName": "Litware",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Rok",
    "LastName": "Palčič",
    "JobTitle": null,
    "Email": "Rok@northwindtraders.com",
    "Phone": "407-967-2237",
    "PaymentTerm": null,
    "CompanyName": "Northwind Traders",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Roland",
    "LastName": "Hofmann",
    "JobTitle": null,
    "Email": "roland@proseware.com",
    "Phone": "408-875-4590",
    "PaymentTerm": null,
    "CompanyName": "Proseware, Inc.",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Ryan",
    "LastName": "Brim",
    "JobTitle": null,
    "Email": "ryan_brim@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Ryan",
    "LastName": "Gregg",
    "JobTitle": null,
    "Email": "ryang@adventure-works.com",
    "Phone": "768-555-0179",
    "PaymentTerm": "Net 30",
    "CompanyName": "Adventure Works",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Ryan",
    "LastName": "Spanton",
    "JobTitle": null,
    "Email": "ryans@alpineskihouse.com",
    "Phone": "789-456-7921",
    "PaymentTerm": "Net 30",
    "CompanyName": "Alpine Ski House",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Samuel",
    "LastName": "McBride",
    "JobTitle": null,
    "Email": "samuel_mcbride@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Simon",
    "LastName": "Raley",
    "JobTitle": null,
    "Email": "simon_raley@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Susan",
    "LastName": "Burk",
    "JobTitle": "Owner",
    "Email": "sueburk@margiestravel.com",
    "Phone": "408-875-4592",
    "PaymentTerm": null,
    "CompanyName": "Margie's Travel",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Summer",
    "LastName": "Knight",
    "JobTitle": null,
    "Email": "summer_knight@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Susanne",
    "LastName": "Schustin",
    "JobTitle": null,
    "Email": "susanne@adatum.com",
    "Phone": "123-879-9900",
    "PaymentTerm": "Net 60",
    "CompanyName": "A. Datum",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tabatha",
    "LastName": "Guy",
    "JobTitle": null,
    "Email": "tabatha_guy@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tamra",
    "LastName": "Riggs",
    "JobTitle": null,
    "Email": "tamra_riggs@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tete",
    "LastName": "Mensa-Annan",
    "JobTitle": null,
    "Email": "tetemensa@humongousinsurance.com",
    "Phone": "123-879-9951",
    "PaymentTerm": null,
    "CompanyName": "Humongous Insurance",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Thiti",
    "LastName": "Wang-Aryattawanich",
    "JobTitle": null,
    "Email": "thiti@litware.com",
    "Phone": "123-879-9952",
    "PaymentTerm": null,
    "CompanyName": "Litware",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tomasz",
    "LastName": "Bochenek",
    "JobTitle": null,
    "Email": "thomasz@cohowinery.com",
    "Phone": "456-698-4581",
    "PaymentTerm": null,
    "CompanyName": "Coho Winery",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tom",
    "LastName": "O'Neill",
    "JobTitle": null,
    "Email": "tom@adatum.com",
    "Phone": "111-587-4594",
    "PaymentTerm": "Net 60",
    "CompanyName": "A. Datum",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tony",
    "LastName": "Sellars",
    "JobTitle": null,
    "Email": "tony_sellars@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Terrence",
    "LastName": "Philip",
    "JobTitle": null,
    "Email": "tphillip@consolidatedmessenger.com",
    "Phone": "789-741-8624",
    "PaymentTerm": "Net 30",
    "CompanyName": "Consolidated Messenger",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Tamer",
    "LastName": "Salah",
    "JobTitle": "Owner",
    "Email": "TSalah@humongousinsurance.com",
    "Phone": "555-789-8880",
    "PaymentTerm": null,
    "CompanyName": "Humongous Insurance",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Ty",
    "LastName": "Tinker",
    "JobTitle": null,
    "Email": "ty_tinker@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Uzi",
    "LastName": "Hefetz",
    "JobTitle": null,
    "Email": "uhefetz@graphicdesigninstitute.com",
    "Phone": "789-741-8629",
    "PaymentTerm": null,
    "CompanyName": "Graphic Design Institute",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Van",
    "LastName": "Amundson",
    "JobTitle": null,
    "Email": "van_amundson@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Viara",
    "LastName": "Kalnakova",
    "JobTitle": null,
    "Email": "viara@lucernepublishing.com",
    "Phone": "123-879-9954",
    "PaymentTerm": null,
    "CompanyName": "Lucerne Publishing",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Vicky",
    "LastName": "Barker",
    "JobTitle": null,
    "Email": "vicky_barker@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Victor",
    "LastName": "Timm",
    "JobTitle": null,
    "Email": "victor_timm@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Viggo",
    "LastName": "Forde",
    "JobTitle": null,
    "Email": "viggo@northwindtraders.com",
    "Phone": "555-123-4905",
    "PaymentTerm": null,
    "CompanyName": "Northwind Traders",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Vincent",
    "LastName": "Lauriant",
    "JobTitle": "Purchasing Manager",
    "Email": "vincent@adatum.com",
    "Phone": "012-156-8778",
    "PaymentTerm": "Net 60",
    "CompanyName": "A. Datum",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Walter",
    "LastName": "Harp",
    "JobTitle": "Owner",
    "Email": "walter@cpandl.com",
    "Phone": "407-967-2241",
    "PaymentTerm": "2% 10, Net 30",
    "CompanyName": "City Power & Light",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Wayne",
    "LastName": "Goolsby",
    "JobTitle": null,
    "Email": "wayne_goolsby@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "William",
    "LastName": "Flash",
    "JobTitle": null,
    "Email": "williamf@alpineskihouse.com",
    "Phone": "178-854-4589",
    "PaymentTerm": "Net 30",
    "CompanyName": "Alpine Ski House",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Wilson",
    "LastName": "Chew",
    "JobTitle": null,
    "Email": "wilson_chew@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Winifred",
    "LastName": "Pollard",
    "JobTitle": null,
    "Email": "winifred_pollard@fabrikam.com",
    "Phone": null,
    "PaymentTerm": null,
    "CompanyName": null,
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Wilson",
    "LastName": "Pais",
    "JobTitle": null,
    "Email": "wparis@cohowinery.com",
    "Phone": "456-698-4582",
    "PaymentTerm": null,
    "CompanyName": "Coho Winery",
    "Country": null,
    "Region": null
  },
  {
    "FirstName": "Yvonne",
    "LastName": "McKay",
    "JobTitle": "Purchasing Manager",
    "Email": "ymckay@proseware.com",
    "Phone": "407-967-2242",
    "PaymentTerm": null,
    "CompanyName": "Proseware, Inc.",
    "Country": null,
    "Region": null
  }
]

Hope it helps...



Comments

Post a Comment

Popular posts from this blog

Read Only Sub Grid & Editable Sub grid in Dynamics 365

Image
Hello Guys, In my previous blogs we have seen Duplicate Detection in Dynamics 365 where we covered how you can use OOB feature of D365 to detect duplicate records. Today we will see how we can implement editable sub grid.  But before if you are new to our blog then do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. In Dynamics CRM we have seen many entities sharing parent child relationships and we can create records of child from the parent page. For example Account and Contact Entity. We can create a new contact entity from the Account Form with the help of Sub Grid control. We can also create sub grid for custom entity and can utilize it in our own way. We will be using Department and Employee Entity for demonstration. Below are the steps: Step 1:- Login to Dynamics 365 with credentials. Step 2:- Click on Advance Settings Gear icon. Navigate to Settings -> Solution -> open the soluti
Read more

Understanding Sales Process in D365.

Image
Hello Guys, In our previous blog we have seen what is Lead and types of leads. Today we are going to understand Sales Process. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Sales Life cycle begins with Lead. Business captures leads through advertising, marketing, trade shows, mailings etc. Whenever organization gets any new lead, Sales Person captures the information of the lead in Lead entity available in Dynamics 365. For creating lead we require only two things, Lead Name and a Topic describing the lead. Once lead creation is completed, Sales Person performs follow up activities by sending emails, appointment and phone calls to collect more information about the lead. Microsoft Dynamics 365 stores these activities in the Activities entity in the system. Leads can be qualified or disqualified. A disqualified lead indicates that the lead is not a good candidate for sales opportunities.
Read more

Understanding Business Unit in Dynamics 365.

Image
Hello Guys, Today we will understand what is Business Unit and how to create Business Unit in D365. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Consider a scenario where you are having more Customers, Leads and Opportunities and you are not able to handle them alone. So as you want to grow more in your business you need to take care of such things too. For handling this you need to create Users, Teams and Business Unit. In our upcoming blogs we will discuss about users and teams too. Business Units are the foundation of the Security Structure in Microsoft Dynamics 365. When you create an organization in CRM, Dynamics automatically creates a root business unit for you. This BU is nothing but your organization and it can not be deleted or disabled except you can change the name of the BU. Once you have root BU, you can create other BU, Teams and Security Roles for identifying your busine
Read more