SharePoint List Columns. Limit Multiple choice of one column based on another column.

%3CLINGO-SUB%20id%3D%22lingo-sub-1136044%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Columns.%20Limit%20Multiple%20choice%20of%20one%20column%20based%20on%20another%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136044%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20lists%20in%20SharePoint.%26nbsp%3B%20List%201%20is%20a%20Client%20Contact%20List.%26nbsp%3B%20List%202%20is%20an%20Account%20Managers%20task%20list.%26nbsp%3B%20Each%20time%20an%20account%20manager%20has%20a%20client%20interaction%20they%20are%20to%20record%20it%20on%20the%20Account%20Managers%20task%20list.%26nbsp%3B%20There%20is%20a%20column%20for%20Client%20and%20also%20a%20column%20for%20Client%20Point%20of%20Contact.%26nbsp%3B%20Client%20Point%20of%20Contact%20is%20a%20look-up%20multiple%20choice%20column%20from%20the%20Client%20contact%20list.%26nbsp%3B%20I%20would%20like%20to%20limit%20the%20multiple-choice%20based%20on%20the%20client%20chosen.%26nbsp%3B%20For%20Example%3A%3C%2FP%3E%3CP%3EIf%20Client%20ABC%20is%20chosen%20and%20Client%20Contact%20List%20has%205%20contacts%20for%20Client%20ABC%20then%20those%20should%20be%20the%20only%20choices%20available.%20Similar%20to%20what%20happens%20in%20Excel.%26nbsp%3B%20if%20I%20have%20a%20column%20and%20I%20filter%20one%20to%20a%20specific%20value%20the%20other%20column%20will%20only%20return%20that%20match%20for%20those%20values.%3C%2FP%3E%3CP%3EApologies%20if%20this%20has%20been%20answered%20somewhere%20else%2C%20I%20have%20spent%20a%20lot%20of%20time%20searching%20for%20an%20answer%20with%20no%20luck.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1136044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1141373%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20Columns.%20Limit%20Multiple%20choice%20of%20one%20column%20based%20on%20another%20column.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1141373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F134846%22%20target%3D%22_blank%22%3E%40Laura%20Cheeping%3C%2FA%3E%26nbsp%3BI%20have%20figured%20out%20that%20i%20can%20do%20this%20with%20cascading%20dropdown%20lookup%20through%20the%20Powerapps.%26nbsp%3B%20However%20I%20am%20having%20trouble%20actually%20creating%20the%20formula's%20in%20PowerApp%20and%20then%20making%20it%20actually%20work%20on%20the%20list.%20I%20will%20continue%20to%20try%20and%20if%20i%20come%20up%20with%20a%20resolution%20will%20post.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have 2 lists in SharePoint.  List 1 is a Client Contact List.  List 2 is an Account Managers task list.  Each time an account manager has a client interaction they are to record it on the Account Managers task list.  There is a column for Client and also a column for Client Point of Contact.  Client Point of Contact is a look-up multiple choice column from the Client contact list.  I would like to limit the multiple-choice based on the client chosen.  For Example:

If Client ABC is chosen and Client Contact List has 5 contacts for Client ABC then those should be the only choices available. Similar to what happens in Excel.  if I have a column and I filter one to a specific value the other column will only return that match for those values.

Apologies if this has been answered somewhere else, I have spent a lot of time searching for an answer with no luck. 

1 Reply

@Laura Cheeping I have figured out that i can do this with cascading dropdown lookup through the Powerapps.  However I am having trouble actually creating the formula's in PowerApp and then making it actually work on the list. I will continue to try and if i come up with a resolution will post.