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 |