I want to create an Advanced smartobject to combine the data from two Sharepoint lists to display in a Listview!
Both the Sharepoint lists are having same data.
For Example: List1 is Sales and List2 is HR
I want to display the data frm both the lists Sales and Hr in the below format. Is this possible using Advanced smartobject.
Listname | IDĀ | Name | Department |
SalesĀ | 1 | abc | dpt1 |
HR | 1 | bcd | dpt2 |
Sales | 1 | abc | dpt1 |
HR | 1 | erf | dpt2 |
Sales | 1 | fgh | dpt1 |
HR | 1 | erf | dpt2 |