Forum Discussion
Lam01007
Dec 12, 2019Copper Contributor
Join 2 SharePoint List
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 ...
Dec 13, 2019
You basically need to use PowerApps to accomplish this in Modern UI. There are multiple ways of accomplishing it, but search around and you should be able to get how to accomplish it. One example here. https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Syntax-for-joining-tables/td-p/61387
Other ways of accomplishing it, but you can't really do this inside of SharePoint itself. You might be able to get creative with PowerAutomate flows to come up with a 3rd (Joined) type list but that could get risky.
Other ways of accomplishing it, but you can't really do this inside of SharePoint itself. You might be able to get creative with PowerAutomate flows to come up with a 3rd (Joined) type list but that could get risky.