cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Getting around the SharePoint LookUp column limit with Choice columns?

Hi everyone,

 

I'm aware of the 12 LookUp column limit in SP Online, but I really need more than that in my use case. I was wondering if anyone is aware of any potential workarounds?

 

I only need the columns to contain information from other lists, no need to cross reference them, so no deleting, or editing of original lists is required from the list containing the LookUp columns.

 

I was thinking maybe there could be a way to have a Choice column that would have values from a different list as options, but not sure how to get started on that. I can get it working as a Text column instead of Choice (having a ComboBox linked to the required list, then concatenating the result into the text data field), but would prefer a Choice column to allow for Filtering.

 

Thanks for your help 🙂 

1 REPLY 1
Drrickryp
Super User
Super User

@Anonymous 

My suggestion is not to use Lookup columns. ref https://warrenbelz.blogspot.com/2020/08/power-apps-delegation-is-word-not.html#comments  Either have separate lists and do the lookups in PowerApps or hard code the dropdowns in PowerApps.  The relationships between the lists is built by including a number column for the foreign key in a list that refers to the primary key (ID) of another list.  ref https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 

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.

Top Solution Authors
Top Kudoed Authors
Users online (1,392)