Approach to linked various lists

%3CLINGO-SUB%20id%3D%22lingo-sub-3436089%22%20slang%3D%22en-US%22%3EApproach%20to%20linked%20various%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3436089%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorking%20in%20Sharepoint%20Lists%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20what%20the%20best%20approach%20is%20to%20display%20columns%20from%20a%20list%20that%20are%20in%20fact%20lookup%20columns%20from%20another%20list.%20Currently%20they%20dont%20appear%20when%20trying%20to%20add%20them%20into%20the%20third%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20Account%20List%2C%20Contact%20List%20then%20the%20most%20important%2C%20a%20list%20called%20Contact%20Accounts%20that%20ties%20the%20Contact%20%26amp%3B%20Account%20list%20together%20by%20way%20of%20a%20Job%20Title.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20now%20trying%20to%20create%20a%20Quote%20list%20that%20will%20tie%20in%20to%20the%20Contact%20Accounts%20list%20but%20want%20to%20show%20fields%20from%20the%20Contact%20Accounts%20list%20that%20are%20in%20fact%20Lookup%20Columns%20from%20the%20Contact%20Accounts%20list%20that%20do%20not%20appear%20as%20an%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESharepoint%20is%20the%20backend%20for%20the%20solution%20so%20I%20am%20wondering%20if%20i%20just%20skip%20trying%20to%20do%20the%20links%20here%20(although%20this%20is%20my%20preference)%20and%20just%20use%20my%20Canvas%20PowerApp%20to%20address%20this%20issue%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20or%20tips%20is%20greatly%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3436089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi,

 

Working in Sharepoint Lists

 

Wondering what the best approach is to display columns from a list that are in fact lookup columns from another list. Currently they dont appear when trying to add them into the third list.

 

I have an Account List, Contact List then the most important, a list called Contact Accounts that ties the Contact & Account list together by way of a Job Title.

 

I am now trying to create a Quote list that will tie in to the Contact Accounts list but want to show fields from the Contact Accounts list that are in fact Lookup Columns from the Contact Accounts list that do not appear as an option.

 

Sharepoint is the backend for the solution so I am wondering if i just skip trying to do the links here (although this is my preference) and just use my Canvas PowerApp to address this issue

 

Any advice or tips is greatly appreciated

0 Replies