Power Platform Community Forum Thread Details

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.

Categories:

Building Power Apps

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.