web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Pro Dev & ISV / Optimising PowerApps p...
Power Apps - Power Apps Pro Dev & ISV
Unanswered

Optimising PowerApps performance - Sharepoint lists look up fields vs numeric primary foreign keys

(0) ShareShare
ReportReport
Posted on by MZ-18110459-0 38
I am trying to decide on the schema of my Sharepoint lists and I was wondering if it better to use lookup fields in the lists to enforce the relationships or to join the data using numeric primary and foreign keys.  Will using the lookup fields slow down the performance of Powerapps or will the manual filtering of the data based on IDs at the time there is a selection in Powerapps slow things down?
 
Thank you :-)
Categories:
Power Apps component framework
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 151,686 Most Valuable Professional on at
    Optimising PowerApps performance - Sharepoint lists look up fields vs numeric primary foreign keys
    Firstly Lookup columns do not actually establish a "server side" relationship with the second list other than the field looked up and any specific "secondary" fields you name in the List Settings of the field. The downside of this field type (I never use them) is that they can cause unnecessary complications in reading from and writing to (they are a complex field type) and have some Delegation restrictions (you cannot Sort by them or use StartsWith() in a Filter). Exactly the same functionality (looking up the other list fields) is generally available directly in Power Apps.
    One good option (in my experience anyway) is to link all "child" lists by a numeric field containing the ID of the "parent". You can also "link" on any common value text field and do the LookUp/Filter in Power Apps, which is fully Delegable. The concept of Primary and Foreign keys does not really apply with SharePoint as it is not a relational database.
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 629 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 232 Moderator

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans