Hi All,
I would like to join 2 lists and display in a single list.
Let say, I have following 2 lists:
Product
| ID | Product Name | Unit Price |
| 1 | A | 100 |
| 2 | B | 200 |
Order
| ID | ProductID (Foreign Key) | Quantity |
| 1 | 1 | 5 |
| 2 | 1 | 4 |
| 3 | 2 | 20 |
Finally, join the above 2 list by the ProductID, and output into following result list:
| OrderID | Product Name | Quantity | Unit Price |
| 1 | A | 5 | 100 |
| 2 | A | 4 | 100 |
| 3 | B | 20 | 200 |
It should be achieved by using the "Content Query Web Part (CQWP)" in previous version of SharePoint, but how can I achieve the above in the Modern SharePoint Online? by using Highlight Content Web Part? or use client-side script to call REST API to join the list and display in a html table?
In advance, can I also apply the SharePoint default list feature into the result list, e.g. Search, sort/filter by column
Many thanks,
Lam
