cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Super User
Super User

Why almost all the videos i watched and documentation i read do not use SharePoint lookups instead they store the Master/Parent id in a field

I watched a lot of videos which show how to build Master/Detailed tables in SharePoint and manage them in Power Apps. Now usually  inside SharePoint when we have Parent/Child or Master/Detailed lists we use a lookup column inside the Child or Detailed to reference the Parent or Master record. but inside all the Power Apps videos which show how to build such an application they do no use any lookup column. Instead they store the Parent or Master ID as plain text inside the Child or Detailed record! so is there any specific reason? is it because dealing with Lookup column inside Power Apps is a bit of pain? 

 

here are some popular videos which  i am taking about:-

 

https://www.youtube.com/watch?v=xgznk4XlPCo

+

https://www.youtube.com/watch?v=SCYY9ZL48Mw&t=962s

 

 

Thanks

 

4 REPLIES 4
Drrickryp
Super User
Super User

@johnjohn123 

Yes!

Pstork1
Dual Super User
Dual Super User

One big reason is that SharePoint lists can only have a very limited number of Lookup columns, 7-8 at most.  Equally important is that Filtering and Sorting by Lookup columns really doesn't work, while sorting by a column that manually records a key in the other record does.  



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1  so you recommend not to use lookups and rely on storing the parent Id inside a free text?

I've done it both ways.  The real point here is that both approaches are an attempt to turn SharePoint into a relational database.  It isn't one and never will be.  If you can use a real database like Dataverse or SQL I would recommend that.  But often there are licensing issues.  If you only need to relate a couple lists then its ok to use a Lookup.  But if its going to be a complex database with a lot of calculations and manipulations its often easier to use the parent ID/child id.  There is no one hard fast rule.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,852)