logo
Documents & Forms
Microsoft 365 & SharePoint Tools
Classic SharePoint Tools
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: