SP List Selections

[NoraM479]

Hi everyone! 

I need desperate help with the below:

I am trying to build a list in SP, where users can go in, and do the following:

1. Select the sales rep.
2. based on that selection, specific client names will show up for the user to select from
3. based on the selected sales rep and client name, the associated opportunity names will show so the user select the appropriate one based on the previous selections. 

Anyone who can help me with the above!!

thank you 

[#2]

Sounds like you need a 'cascading drop down list'. This blog might help
https://sharepointmaven.com/3-alternatives-to-building-cascading-drop-downs-in-sharepoint/

[#3]

@NoraM479 instead of the standard SharePoint form you can have a Power Apps customised form for your list and have cascading dropdowns in that by adding additional data sources, e.g. your client list and opportunity names. Let me know if you need some screeenshots of how it's done.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

[#4]

Yes PLEASE!!! I need screenshots!!! THANK YOU THANK YOU