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):
And Products List, with two columns as well — Title and Category (Lookup):
Finally, Orders will also contain two columns — Title and License (Choice):
If you add one more column (Multiline Plain Text), the DataTable can then be saved to this new column:
For more information, please, check out this article on dynamic DataTable.