SOLVED

Filter drop down based o view

%3CLINGO-SUB%20id%3D%22lingo-sub-1432798%22%20slang%3D%22en-US%22%3EFilter%20drop%20down%20based%20o%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432798%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20my%20comopany%20we%20have%20customers%20than%20are%20members%20of%20groups.%3C%2FP%3E%3CP%3EI%20like%20to%20build%20a%20list%20so%20that%20they%20can%20add%20new%20members%20and%20delete%20members%20themselfes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EList%20A%20contains%20the%20group%20name%2C%20ID%20and%20additional%20information%3C%2FP%3E%3CP%3EList%20B%20contains%20the%20members%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20filtered%20list%20B%20so%20that%20the%20logged%20in%20person%20can%20just%20see%20the%20records%20they%20should%20see.%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3EGrp%201%20members%3C%2FP%3E%3CP%3EGrp%202%20members%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20they%20should%20add%20a%20new%20member%20they%20need%20to%20choose%20which%20group%20it%20should%20be%20added%20to%20and%20I%20then%20want%20to%20limit%20the%20choices%20to%20the%20group%20IDs%20in%20the%20view.%3C%2FP%3E%3CP%3EThe%20view%20shows%20group%201%20and%202%20how%20can%20I%20limit%20the%20lookup%20column%20that%20gets%20the%20groups%20from%20list%20A%20to%20just%201%20and%202%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1432798%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-1433090%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20drop%20down%20based%20o%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433090%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F620806%22%20target%3D%22_blank%22%3E%4036048419%3C%2FA%3E%26nbsp%3B%3A%20This%20is%20very%20much%20possible%20through%20lookup%20column%20functionality%2C%20this%20is%20called%20cascading%20i.e.%20based%20on%20the%20selection%20of%20one%20column%20value%20it%20will%20show%20only%20related%20values%20in%20another%20column.%3C%2FP%3E%3CP%3EWhich%20form%20type%20you%20are%20using%20%3A%3C%2FP%3E%3CP%3E1)%20SharePoint%20out%20of%20box%20(aspx)%20form%3C%2FP%3E%3CP%3E2)%20InforPath%3C%2FP%3E%3CP%3E3)%20PowerApps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433101%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20drop%20down%20based%20o%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679665%22%20target%3D%22_blank%22%3E%40Ashish_Kohale%3C%2FA%3E%26nbsp%3BAt%20the%20oment%20we%20just%20have%20Sharepoint.%20Wish%20I%20hade%20Power%20Apps%20so%20I%20could%20make%20it%20a%20little%20bit%20more%20user%20friendly%20looking%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433140%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20drop%20down%20based%20o%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F620806%22%20target%3D%22_blank%22%3E%4036048419%3C%2FA%3E%26nbsp%3B%3A%20Can%20you%20please%20search%20on%20google%20with%20cascading%20functionality%2C%20you%20will%20find%20client%20side%20script%20to%20achieve%20this%20or%20else%20let%20me%20know%20if%20you%20need%20any%20help%20on%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20have%20answered%20your%20question%2C%20please%20mark%20your%20post%20as%20Solved.%3CBR%20%2F%3EIf%20you%20like%20my%20response%2C%20please%20give%20it%20a%20Thumbs%20Up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433170%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20drop%20down%20based%20o%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433170%22%20slang%3D%22en-US%22%3E%3CP%3ESince%20you%20have%20SharePoint%20Online%2C%20yo%20also%20have%20PowerApps%20to%20use%20in%20your%20tenant%20so%20you%20could%20implement%20the%20cascading%20functionality%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

 

At my comopany we have customers than are members of groups.

I like to build a list so that they can add new members and delete members themselfes.

 

List A contains the group name, ID and additional information

List B contains the members

 

I have filtered list B so that the logged in person can just see the records they should see. 

For example:

Grp 1 members

Grp 2 members

 

When they should add a new member they need to choose which group it should be added to and I then want to limit the choices to the group IDs in the view.

The view shows group 1 and 2 how can I limit the lookup column that gets the groups from list A to just 1 and 2?

4 Replies
Best Response confirmed by 36048419 (Contributor)
Solution

@36048419 : This is very much possible through lookup column functionality, this is called cascading i.e. based on the selection of one column value it will show only related values in another column.

Which form type you are using :

1) SharePoint out of box (aspx) form

2) InforPath

3) PowerApps

@Ashish_Kohale At the oment we just have Sharepoint. Wish I hade Power Apps so I could make it a little bit more user friendly looking though.

@36048419 : Can you please search on google with cascading functionality, you will find client side script to achieve this or else let me know if you need any help on this.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

 

 

Since you have SharePoint Online, yo also have PowerApps to use in your tenant so you could implement the cascading functionality