O'Reilly logo

Extending Microsoft Dynamics AX 2012 Cookbook by Murray Fife

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building InfoPath lookups using OData queries

A feature of InfoPath that makes forms even more useful is the ability to allow fields to be populated with dynamic data coming from static lists, databases, and also web data sources, so that users do not have to remember field values such as part codes and customer numbers. Since you are able to query Dynamics AX data through web queries, we can use these queries to create dynamic lookups in our forms.

In this recipe, we will show how you can turn text fields into drop-down lists that use OData queries as a data source.

How to do it...

To use an OData query as a data source for a field, follow these steps:

  1. We need to first define the data source. To do this, select the From XML File option in the From ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required