Web part or Power App that will allow pulling data from two lists

153 viewsDevelopment

In SharePoint Online, Out-of-the-Box, I have not found a way to solve a one-to-many relationship.  I am a junior member of a Dev team and I would like to understand how I could do the following:

List-1 is product inventory list (primay key = product #) contains “Product #” field and at laest 10 fields for each product.

List-2 has “Product #” , Location #, multiple buildings & rooms where these products are stored 

Example of data in List-2

Product #      Location #       Building Name       Room Name or #

Product-001      L-001             Building-A           Janitor Closet
Product-001      L-002             Building-A           Operations Sink Cabinet
Product-001      L-003             Building-B           Janitor Closet
Product-001      L-004             Building-B           Maintenance Rm#10
Product-002      L-001             Building-A           Maintenance Rm#2
Product-002      L-002             Building-A           Emergency Generator
Product-002      L-003             Building-B           Lab-789
Product-002      L-004             Building-C           Lab-456

User requested search “by Building” results:

Search results for Building-A

(First Column comes from List-2)                     (All other columns comes from List-1)

Room Name or #                                              Product #      other List-1 columns…
Janitor Closet; Operations Sink Cabinet              Product-001      
Maintenance Rm#2; Emergency Generator         Product-002

Answered question
Add a Comment

We give your substance the most obvious opportunity it can need to rank for pertinent catchphrases and expressions. There are more eCommerce alternatives accessible today than at any time in recent memory. It’s additionally simpler and more moderate than any other time in recent memory to sell on the web. Get in touch with us to talk about your extend and figure out which eCommerce arrangement is generally fitting for your long and transient objectives. For a long time, we’ve helped our clients increment profitability with custom web applications constructed only for them.

In case we’re going to do this, we’re going to do it right. Accomplices the entire way. Since the enchantment occurs in that space between the development encounters that construct brand dedication and the client encounters that reward them. Website Development Company In Delhi help the company in each vertical go-to-showcase and develop by working together, executing, and continually improving a custom methodology.

Answered question
Add a Comment