Forum Discussion
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 ...
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.