Replacing textbox to Dropdown in sharepoint form

%3CLINGO-SUB%20id%3D%22lingo-sub-1422788%22%20slang%3D%22en-US%22%3EReplacing%20textbox%20to%20Dropdown%20in%20sharepoint%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422788%22%20slang%3D%22en-US%22%3E%3CP%3Eplease%20check%20attached%20screenshot%2CI%20have%20one%20list%2C%20when%20click%20on%20new%20Item%20form%20get%20open%2C%3C%2FP%3E%3CP%3Ein%20that%20form%20I%20have%20text%20box%20for%20%22Vendor%22%20and%20I%20want%20to%20replace%20that%20textbox%20with%20dropdown%20list%2C%20so%20when%20we%20add%20new%20item%20%2C%20for%20Vendor%20use%20have%20to%20select%20it%20from%20drop%20down%20list.%3C%2FP%3E%3CP%3Ecan%20anyone%20tell%20me%20steps%20that%20I%20need%20to%20follow.%20or%20link%20of%20article%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1422788%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%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-1423541%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20textbox%20to%20Dropdown%20in%20sharepoint%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423541%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670519%22%20target%3D%22_blank%22%3E%40rautchetan27%3C%2FA%3E%26nbsp%3Bif%20you%20go%20to%20List%20settings%20you%20can%20change%20the%20column%20type%20to%20a%20Choice%20column%20which%20will%20include%20all%20the%20entries%20that%20have%20been%20made%20so%20far.%20If%20your%20vendors%20are%20in%20a%20separate%20list%20then%20you've%20got%20a%20couple%20of%20options%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%26nbsp%3B-%20The%20first%20is%20to%20create%20a%20Lookup%20column%20to%20the%20list%20of%20vendors%20on%20your%20site.%20That's%20the%20simplest%20way%20to%20do%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20The%20second%20is%20to%20use%20a%20customised%20Power%20Apps%20form%20instead%20of%20the%20default%20SharePoint%20form%20and%20have%20a%20dropdown%20that%20looks%20up%20the%20list%20of%20vendors%20and%20saves%20the%20selected%20one%20back%20to%20the%20text%20column.%20In%20the%20example%20below%20I%20have%20a%20list%20with%20a%20column%20called%20Role%20which%20is%20a%20single%20line%20of%20text%20column%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-SP-List.png%22%20style%3D%22width%3A%20897px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195004i0F7EF007DFE6FEB4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220-SP-List.png%22%20alt%3D%220-SP-List.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20that%20column%20I%20want%20to%20lookup%20items%20from%20the%20Resource%20list%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Lookup-List.png%22%20style%3D%22width%3A%20538px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195003iB003EF289E9DD0FE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221-Lookup-List.png%22%20alt%3D%221-Lookup-List.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20customised%20form%20which%20lists%20all%20the%20roles%20from%20the%20Resource%20list.%20In%20this%20example%20I've%20added%20a%20filter%20as%20well%20for%20the%20type%20of%20role%20and%20am%20displaying%20the%20results%20in%20table%2C%20but%20you%20could%20just%20have%20the%20dropdown%20display%20the%20vendors.%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Form.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195005i7CDD26C6FC261C9B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222-Form.png%22%20alt%3D%222-Form.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20selected%20item%20is%20saved%20back%20to%20the%20single%20line%20of%20text%20column.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-SP-List-itemAdded.png%22%20style%3D%22width%3A%20818px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195002i3246ADCE391D4EB6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%223-SP-List-itemAdded.png%22%20alt%3D%223-SP-List-itemAdded.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

please check attached screenshot,I have one list, when click on new Item form get open,

in that form I have text box for "Vendor" and I want to replace that textbox with dropdown list, so when we add new item , for Vendor use have to select it from drop down list.

can anyone tell me steps that I need to follow. or link of article

1 Reply

@rautchetan27 if you go to List settings you can change the column type to a Choice column which will include all the entries that have been made so far. If your vendors are in a separate list then you've got a couple of options:

 - The first is to create a Lookup column to the list of vendors on your site. That's the simplest way to do it.

 

- The second is to use a customised Power Apps form instead of the default SharePoint form and have a dropdown that looks up the list of vendors and saves the selected one back to the text column. In the example below I have a list with a column called Role which is a single line of text column:

0-SP-List.png

 

For that column I want to lookup items from the Resource list:

1-Lookup-List.png

 

This is the customised form which lists all the roles from the Resource list. In this example I've added a filter as well for the type of role and am displaying the results in table, but you could just have the dropdown display the vendors.: 

2-Form.png

 

The selected item is saved back to the single line of text column.

3-SP-List-itemAdded.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User