cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Understanding SharePoint Column Lookup

Hello Guys,

I have this question, and I would like to get an advice here:

Currently I have two SharePoint lists 

"Orders"

"Country"

 

In my "Orders" lists I have a Lookup column that brings me the CountryID and also the country name.

 

My question is:

I can leave my Orders lists as it is and show only my CountryID, or I can ADD columns of the additional fields to my list. Considering that my Orders list is a "Giant" list in terms of columns.

 

By doing this I am saving lots of formulas in powerapps trying to resolve the Lookup question. I mean if I select the CountryID the rest is easy, other ways I have to manually add Lookup(Country, ID = ......etc, etc etc.

 

Now saying that:

Adding those extra columns to my SPL will decrease list performance?

Adding those extra Lookup labels in my PowerAPP will decrease APP performance?

 

Thanks in advance for any response.

 

Regards.

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Understanding SharePoint Column Lookup

Yes this is correct. More lookups will decrease performance in both SP and PowerApps , so I recommend you mix between lookups and direct adding choices for the dropdowns based on your requirement , So

If you have

  • Ease of adding new values by end users > Look up.
  • Ensuring that list values are relevant/ controlled > Choice.
  • Ability to use in views > Choice.
  • Performance > Choice.
  • Communicating choice options > Lookup.
  • Displaying related information > Lookup.
  • Including default values > Draw – it depends on the experience you are trying to achieve.
  • User experience and data updates when a value changes > Probably Lookup.
  • “Out of the box” Data Entry Experience > Lookup.

For more details check this

 
Please notes, The lookup column threshold limit it the maximum number (12) of lookup columns existing in PowerApps. When you go over this limit you will receive the following error.

“The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.”

The threshold limit is set by Microsoft and cannot be changed. The reason this limit exists is to make sure the performance of the PowerApps is up to standards.

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Understanding SharePoint Column Lookup

Yes this is correct. More lookups will decrease performance in both SP and PowerApps , so I recommend you mix between lookups and direct adding choices for the dropdowns based on your requirement , So

If you have

  • Ease of adding new values by end users > Look up.
  • Ensuring that list values are relevant/ controlled > Choice.
  • Ability to use in views > Choice.
  • Performance > Choice.
  • Communicating choice options > Lookup.
  • Displaying related information > Lookup.
  • Including default values > Draw – it depends on the experience you are trying to achieve.
  • User experience and data updates when a value changes > Probably Lookup.
  • “Out of the box” Data Entry Experience > Lookup.

For more details check this

 
Please notes, The lookup column threshold limit it the maximum number (12) of lookup columns existing in PowerApps. When you go over this limit you will receive the following error.

“The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.”

The threshold limit is set by Microsoft and cannot be changed. The reason this limit exists is to make sure the performance of the PowerApps is up to standards.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,822)