Display Data From Other List in a List Form Using REST

Here in this example, we have a list called Tracker and another list - Configuration.

In the new form of Tracker, we want to display a particular row’s data from Configuration list.

This row would give information to the user who is filling the tracker, that for the current week, the review would be done for a particular division (this data is updated by some admin in the configuration list)

Here is the structure of the main list - Tracker.



Here is the structure of the configuration list. Please note that the details you want displayed on the other’s list’s form - cannot be of type choice / lookup. InfoPath doesn’t handle these types in REST queries.



I have 3 rows of data in the Configuration list. The admin enters /updates the list, say every week.



In the Trackers’ form, we want to display the most recent ( by week) data. That is display a message that the division that is to be reviewed in the “3rd week of December “ is “Admin”. This message would need to be displayed at run time - bringing the latest value from the configuration list.

Now, let us customize the Tracker list’s “New Form” using InfoPath as shown below.



1. When the form opens in InfoPath designer, click on the “Manage Data Connections” link as shown below.



2. Click on the Add button to add a new data connection.



3. Ensure this is a connection to receive data



4. Select the source for the data to be a REST web service as shown here.



5. Enter the REST service details in the following format:

http://<YourSharePointSite>/_vti_bin/listdata.svc/<ListName>/?$select=<Field1>,<Field2>&$orderby=<Field>&$<other filter criteria>
In my case, it is

http://<MySite>/_vti_bin/listdata.svc/Configuration/?$select=Title,Week,ReviewDivision&$orderby=Week desc&$top=1