cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bunly11
Helper IV
Helper IV

How do I connect two Sharepoint List with a customize form?

Hi all  -

 

I have a customized powerapp form for a sharepoint list.

I want to separate out the supplies. Each item could have up to 10 supplies. 

I would like to be able to add a supplies form (previously I have on one large list). transfer the data.

I am not sure how to connect the two forms.

List one (customized form) is: Bunly11_0-1610515194928.png

List two: Bunly11_2-1610515361497.png

 

I tried below but was not successful

Bunly11_3-1610515437852.png

 

Would anyone have suggestions how to make this work or another suggestion?

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User II
Super User II

Hi @Bunly11 

You have a one to many relationship between your Item and Supply list. Please see my blog on https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-...  about how to set up the relationship.

View solution in original post

3 REPLIES 3
Drrickryp
Super User II
Super User II

Hi @Bunly11 

You have a one to many relationship between your Item and Supply list. Please see my blog on https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-...  about how to set up the relationship.

View solution in original post

Hi @Drrickryp 

Thank you for the blog post. It was very useful. I have always had issues creating one to many relationships. 

Probably why I made one gigantic Access Database list. I was able to connect the lists using.

I was not able to use DrugID in my original list so I made a "NewDrug ID" and it seemed to work.

 

LookUp(SuppliesTBL, NewDrugID = SharePointIntegration.Selected.DrugID)

Drrickryp
Super User II
Super User II

If you have some time,  check out the.blog from the beginning. https://powerusers.microsoft.com/t5/News-Announcements/Database-Design-Fundamentals-and-PowerApps-An...  It's not enough to know how, you should also know why.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (46,458)