Unanswered

Add related items to record using the same list items

(0) Share

Report

Posted on by JennC26

Hello!

I have a SharePoint list of projects with a lot of information being tracked about each project. I now want to add a "related projects" option where users can pull up a project and identify any other projects in the same list as related. What is the best way to create a column to store the related projects so that I can update my Power App accordingly? Right now I'm just using the basic forms control due to time constraints. Down the road, I'd like to consider building a more customized input screen.

I tried adding a lookup column that pulls in all the projects in the list, but couldn't get that to play nicely in Power Apps- my form wouldn't show the lookup column as a field, and I wasn't exactly sure how to patch that information back to SharePoint.

I thought about building a collection on app start to collect all of the items in the list, then within my form, creating a collection of the related projects, but wasn't sure the best way to write those back to SharePoint.

Looking for advice/best practices for this type of relationship. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 155,315 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@JennC26 ,

Firstly, you are right that Lookup columns are not really designed for Power Apps and there are things that are made considerably more complex unnecessarily. The easiest way the "relate" lists is to store the ID of the "parent" in a Numeric field in the "child" (I call mine IDRef) when you create the record. You then do a Filter function in a gallery

Filter( Child, IDRef = YourParentID )

to display all related records.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
JennC26 64 on at

Like (0)

Report
Copy link

Link copied!

Thanks, @WarrenBelz! Would you recommend creating an additional text column and number column to write and store those related fields to then?

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@JennC26 ,

A number column is best as you can store the ID (a unique value which will not change) of the parent record.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No