Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

VIDEO – Query MS Dataverse tables with FetchXML Builder and XRMToolBox

Wanted to share awesome demo with complete end-to-end steps for how to download, install, configure, and use Fetch XML Builder to query Microsoft Dataverse Tables for PowerPlatform, PowerApps, PowerAutomate, and more.

Cheers

Video

Code

<fetch top="50" aggregate="true" >
  <entity name="contact" >
    <attribute name="address1_stateorprovince" alias="contactstate" groupby="true" />
    <attribute name="contactid" alias="contactcount" aggregate="count" />
  </entity>
</fetch>

Screenshots

References

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲