Add 2 sharepoint list in a single datatable with grouping enabled

Add 2 sharepoint list in a single datatable with grouping enabled

NagarajanENagarajanE Posts: 6Questions: 4Answers: 0

Hi Team,

I have a requirement it has 2 list. One is main list it has document no and child list has document no, employee name, dob.

Now i have to show these 2 list in single datatable with grouping.

Document No1
DocumentNo: Employeename1, dob
DocumentNo: Employeename2, dob
DocumentNo: Employeename3, dob
Document No2
DocumentNo: Employeename1, dob
Document No3
DocumentNo: Employeename5, dob
DocumentNo: Employeename6, dob
DocumentNo: Employeename10, dob
DocumentNo: Employeename12, dob
Document No4
DocumentNo: Employeename, dob

Like this i have to show could you please tell me how to do it. I am using pnp js for querying the items from sharepoint list.

Thanks
Nagarajan

This discussion has been closed.