You’re offline. This is a read only version of the page.
Announcements
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 🙂
@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
Share
Report
All responses (
Answers (
759
