logo
Forms
Oct 13, 2019

Dynamic DataTable content from SharePoint Lists

Customer Support Engineer

In this article, we’ll show you how to use Plumsail Forms to place a DataTable control on a SharePoint form which will load values from other Lists, even if they are located in another Site Collection.

You will need to install Plumsail Forms, and create 3 Lists.

In this example, we will use Categories List with two columns — Title and License (Choice):

2

And Products List, with two columns as well — Title and Category (Lookup):

3

Finally, Orders will also contain two columns — Title and License (Choice):

4

Now, you can create a form for the Order List and with DataTable control and some JavaScript, you can load values from Categories and Products Lists, making sure that only appropriate items can be selected.

5

If you add one more column (Multiline Plain Text), the DataTable can then be saved to this new column:

6

For more information, please, check out this article on dynamic DataTable.

Note: The post has been originally published at: