cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamesaw24
New Member

Tie Sharepoint lists together

Hi, I am working on a client tracking application for our company.

 

Our app is set up as follows:

MainSplashScreen -> Manual GUI with 3 options for Recurring Contracts, Commercial and Residential.

       Each of these buttons will direct you to a new screen. i.e.: Commercial will direct you to CommercialSplashScreen.

From CommercialSplashScreen, it displays a list of our Commercial clients. This is a sharepoint list and is an actively updated list. Pressing on one of the clients will take you to the CommercialClientsDetail screen. This information directly corresponds to the data in the Commercial Client Sharepoint list.

 

Our need is to add an option from inside that Detail screen to "view more" about the client and have it dynamically send you to another list. i.e.: From inside Acme Building CommercialClientsDetail screen, there needs to be a button that when pressed will send you to a list elsewhere on Sharepoint named AcmeBuildingUnits. The screen will then display all units that we have built for Acme that are listed in the AcmeBuildingUnits sharepoint list.

 

This "view more" option can be expansion dots, hamburger, whatever but needs to link to specific sharepoint lists depending on which client from the CommercialClientsDetail screen we are in. I do not want to link directly to the sharepoint list with an HTML link and have it pull you from the app to a browser. I would like for the functionality to stay within the app.

 

Thanks for your help!

4 REPLIES 4
Drrickryp
Super User
Super User

Hi @jamesaw24,

Could you please detail the structure of the underlying data.  Is the Commercial clients details list a one-to-one or one to many relations to the Clients list.  Clearly, the AcmeBuildingUnits are a one-to-many relationships to the Clients details list.  In order to link these lists, there needs to be a foreign key from the one side of the relationship in the many side.  Please review my blog posts in the Community Blog section if you are not familiar with these concepts.

Thanks for the reply, I read through your blog posts but they are vague about tying the data itself together. You mention different tables with unique IDs to tie datasets but dont list how to form that relationship. Access is being phased out according to MS so where would you suggest creating the tables?

Hi @jamesaw24,

As far as I know, Desktop Access is not being phased out.  I typically create my tables there and then export them one by one to Sharepoint.  However, you can also create your lists in Sharepoint.  I create the relationships in PowerApps primarily using the Lookup() function and Dropdown controls. The only requirement is that the Child list (the Many side of the relationhip) contains a number column that is named for the the Parent's ID (One side of the relationship).  So if you have three lists  Customers, Orders, and Products, the Orders list should have a column named CustomerID and a column called ProductID both should be a Number type column.  You don't have to worry about creating the relationships in the Source program as that is done from within Powerapps. 

Anonymous
Not applicable

Thanks for your help with this thread @Drrickryp.

 

@jamesaw24 can you review the updated information and advise if you need further assistance?

 

@Anonymous

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,888)