Home

Dropdown list filtering

%3CLINGO-SUB%20id%3D%22lingo-sub-738779%22%20slang%3D%22en-US%22%3EDropdown%20list%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738779%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20i%20have%20two%20list%3A%3C%2FP%3E%3CP%3E1%20Project%20list%20(that%20takes%20requests%20from%20request%20list)%3C%2FP%3E%3CP%3E2%20Request%20list%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20make%20a%20dropdown%20list%20in%20project%20but%20i%20want%20to%20see%20only%20untaken%20requests.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EProject%201%3A%3C%2FP%3E%3CP%3Edropdown%20list%3A%3C%2FP%3E%3CP%3ERequest%20a%20(selected)%3C%2FP%3E%3CP%3ERequest%20b%20(selected)%3C%2FP%3E%3CP%3ERequest%20c%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eafter%20a%20while%20i%20make%20Project%202%20where%20only%20request%20c%20is%20avilable%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProject%202%3A%3C%2FP%3E%3CP%3Edropdown%20list%3A%3C%2FP%3E%3CP%3ERequest%20c%3C%2FP%3E%3CP%3E(a%20and%20b%20were%20taken%20i%20project%201)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20to%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738779%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%3CLINGO-SUB%20id%3D%22lingo-sub-738996%22%20slang%3D%22en-US%22%3ERe%3A%20Dropdown%20list%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738996%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20have%20to%20provide%20some%20custom%20UI%20to%20achieve%20this%20since%20SharePoint%20List%20Forms%20out%20of%20the%20box%20don't%20allow%20you%20to%20specify%20such%20behavior.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20several%20ways%20you%20can%20consider%20to%20provide%20this%20custom%20UI%3A%3C%2FP%3E%3CUL%3E%3CLI%3EUse%20PowerApps%20to%20customize%20your%20list%20forms%20(I'm%20not%20100%25%20sure%20you%20can%20achieve%20what%20you%20want).%26nbsp%3B%3C%2FLI%3E%3CLI%3EUse%20SharePoint%20Framework%20extensions%20(Field%20Customizers)%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fspfx%2Fextensions%2Foverview-extensions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fspfx%2Fextensions%2Foverview-extensions%3C%2FA%3E%3C%2FLI%3E%3CLI%3EManage%20your%20list%20content%20using%20a%20custom%20SharePoint%20Framework%20WebPart%20(and%20provide%20some%20way%20to%20prevent%20managing%20the%20lists%20using%20the%20default%20UI%3F)%3C%2FLI%3E%3CLI%3EProvide%20a%20custom%20(web)%20application%20making%20use%20SharePoint%20API's%20manage%20your%20list%3C%2FLI%3E%3C%2FUL%3E%3CP%3EHope%20this%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738998%22%20slang%3D%22en-US%22%3ERe%3A%20Dropdown%20list%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1803%22%20target%3D%22_blank%22%3E%40Paul%20Pascha%3C%2FA%3E%26nbsp%3BI%20tried%20to%20do%20a%20%22invisible%22%20list%20(request%20not%20taken)%20that%20moves%20items%20to%20%22finished%20request%20list%22%20after%20the%20project%20has%20been%20created%20...%20my%20problem%20was%20that%20I%20can't%20manage%20this%20in%20Microsoft%20Flow%20because%20I%20lost%20link%20connection%20to%20items%20in%20finished%20items...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Jacek88
New Contributor

Hi i have two list:

1 Project list (that takes requests from request list)

2 Request list

 

I want to make a dropdown list in project but i want to see only untaken requests.

 

Example:

Project 1:

dropdown list:

Request a (selected)

Request b (selected)

Request c

 

after a while i make Project 2 where only request c is avilable:

 

Project 2:

dropdown list:

Request c

(a and b were taken i project 1)

 

how to do it?

2 Replies
Highlighted

You have to provide some custom UI to achieve this since SharePoint List Forms out of the box don't allow you to specify such behavior. 

 

There are several ways you can consider to provide this custom UI:

  • Use PowerApps to customize your list forms (I'm not 100% sure you can achieve what you want). 
  • Use SharePoint Framework extensions (Field Customizers)
    https://docs.microsoft.com/en-us/sharepoint/dev/spfx/extensions/overview-extensions
  • Manage your list content using a custom SharePoint Framework WebPart (and provide some way to prevent managing the lists using the default UI?)
  • Provide a custom (web) application making use SharePoint API's manage your list

Hope this helps!

Highlighted

@Paul Pascha I tried to do a "invisible" list (request not taken) that moves items to "finished request list" after the project has been created ... my problem was that I can't manage this in Microsoft Flow because I lost link connection to items in finished items...

Related Conversations
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
6 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
Excel ComboBox (ActiveX Controls) dropdown not functioning
Kpizzle in Excel on
1 Replies
SharePoint List Drag item Move error
mvas111 in SharePoint on
0 Replies
SPO list jumps to top when loading new items
ABehrens in SharePoint Developer on
1 Replies