Drop List List

%3CLINGO-SUB%20id%3D%22lingo-sub-376787%22%20slang%3D%22en-US%22%3EDrop%20List%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376787%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20have%20a%20form%20built%20on%20a%20SharePoint%20List%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20the%20items%20is%20a%20dropdown%20list%20with%203%20options%20plus%20a%20%22other%22%20option.%3C%2FP%3E%3CP%3EWe%20want%20the%20user%20to%20be%20given%20a%20choice%20to%20type%20in%20a%20answer%20if%20it%20not%20one%20of%20the%203%20pre-defined%20options.%3C%2FP%3E%3CP%3EThis%20work%20fine%20however...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20add%20a%20type%20in%20a%20answer%20this%20gets%20added%20to%20the%20List%20and%20then%20the%20next%20time%20you%20open%20the%20form%20you%20last%20answer%20is%20a%20option%20in%20the%20dropdown%20list%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20don't%20want%20this%20to%20happen%20we%20just%20want%20the%20drop%20down%20list%20to%20always%20have%203%20options%20plus%20Other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20how%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-376787%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377027%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20List%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272339%22%20target%3D%22_blank%22%3E%40Pn1995%3C%2FA%3E%26nbsp%3Bactually%2C%20I%20wanted%20to%20thank%20you%20for%20pointing%20out%20this%20feature.%20I've%20never%20liked%20the%20choice%20with%20fill%20in%20options%2C%20because%20you%20could%20never%20really%20see%20all%20of%20the%20other%20-%20you'd%20probably%20have%2012%20different%20spellings%20of%20the%20same%20'other'%20option.%20Now%20a%20user%2C%20if%20they%20need%20to%20use%20something%20not%20in%20the%20formal%20options%2C%20can%20at%20least%20pick%20the%20same%20spelling%20as%20someone%20else.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20doesn't%20change%20the%20actual%20definition%20of%20the%20choice%20field%20-%20it%20still%20has%20the%20original%20options%20you%20gave%20it.%20In%20the%20new%2Fedit%20forms%20the%20options%20under%20the%20line%20are%20all%20the%20values%20that%20have%20been%20used%20in%20other%20items%20(if%20you%20clear%20those%20items%20up%20they%20don't%20show%20any%20more).%20Editing%20in%20quick%20edit%20mode%20doesn't%20show%20those%20'others'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20like%20it%20because%20now%20I%20can%20see%20what%20are%20common%20'other'%20options%20and%20add%20those%20to%20the%20legal%20options..%20So%20for%20me%2C%20it's%20a%20good%20feature.%20Understand%20if%20it%20doesn't%20work%20for%20everyone.%20I%20haven't%20tested%20that%20kind%20of%20field%20to%20see%20what%20PowerApps%20does%20to%20it%2C%20but%20I%20like%20how%20the%20standard%20forms%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-376903%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20List%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376903%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272339%22%20target%3D%22_blank%22%3E%40Pn1995%3C%2FA%3E%2C%20for%20your%20ideal%20scenario%20to%20work%2C%20you're%20asking%20to%20break%20Choice%20fields.%20While%20I'm%20not%20well-versed%20in%20the%20what%20PowerApps%20can%20do%20to%20override%20a%20list's%20data%20integrity%20rules%2C%20I'm%20not%20sure%20it%20can%20do%20that%20without%20creating%20some%20issues%20for%20you.%20Your%20next%20best%20lead%20would%20be%20to%20see%20if%20you%20can%20use%20PowerApps%20to%20force%20a%20limited%20amount%20of%20choices%20in%20a%20Single%20Line%20of%20Text%20field%2C%20but%20someone%20could%20always%20move%20behind%20the%20PowerApps%20form%20and%20interact%20with%20the%20list%20directly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20know%20your%20business%20need%20better%20than%20I%20do%2C%20but%20I%20would%20seriously%20examine%20the%20need%20to%20have%20all%20of%20those%20values%20in%20the%20same%20field.%20Unless%20PowerApps%20comes%20through%20with%20either%20of%20the%20solutions%20above%2C%20you%20might%20need%20to%20decide%20whether%20you%20want--integrity%20of%20your%20data%20in%20two%20fields%20or%20taking%20a%20risk%20in%20that%20integrity%20and%20having%20one%20field.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-376836%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20List%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376836%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F115528%22%20target%3D%22_blank%22%3E%40Matt%20Coats%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3BIf%20we%20had%20another%20field%20added%2C%20we%20would%20want%20it%20saved%20back%20to%20the%20same%20field%20in%20a%20SharePoint%20list%20that%20had%20the%20drop%20down%2C%20so%20i'm%20not%20sure%20it%20would%20help%20would%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20the%20form%20already%20has%20quite%20a%20few%20fields%20so%20having%20another%20would%20add%20to%20an%20already%20crowded%20page%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-376831%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20List%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272339%22%20target%3D%22_blank%22%3E%40Pn1995%3C%2FA%3E%26nbsp%3B%20While%20I'm%20sure%20there's%20a%20solution%20to%20your%20exact%20use%20case%2C%20I%20wonder%20if%20you%20can%20achieve%20what%20is%20effectively%20the%20same%20result%20with%20a%20different%20approach%20that%20wouldn't%20take%20as%20much%20effort%20to%20implement.%20What%20if%20you%20added%20some%20branching%20logic%20to%20make%20a%20new%20field%20appear%20in%20your%20form%20when%20Other%20is%20chosen%20that%20prompts%20them%20to%20type%20in%20their%20value%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi

I have a form built on a SharePoint List

 

One of the items is a dropdown list with 3 options plus a "other" option.

We want the user to be given a choice to type in a answer if it not one of the 3 pre-defined options.

This work fine however...

 

If you add a type in a answer this gets added to the List and then the next time you open the form you last answer is a option in the dropdown list

 

We don't want this to happen we just want the drop down list to always have 3 options plus Other.

 

Any ideas how to do this?

 

Thanks

4 Replies
Highlighted

@Pn1995  While I'm sure there's a solution to your exact use case, I wonder if you can achieve what is effectively the same result with a different approach that wouldn't take as much effort to implement. What if you added some branching logic to make a new field appear in your form when Other is chosen that prompts them to type in their value?

Highlighted

Thanks @Matt Coats

 If we had another field added, we would want it saved back to the same field in a SharePoint list that had the drop down, so i'm not sure it would help would it?

 

Also the form already has quite a few fields so having another would add to an already crowded page

 

Highlighted

@Pn1995, for your ideal scenario to work, you're asking to break Choice fields. While I'm not well-versed in the what PowerApps can do to override a list's data integrity rules, I'm not sure it can do that without creating some issues for you. Your next best lead would be to see if you can use PowerApps to force a limited amount of choices in a Single Line of Text field, but someone could always move behind the PowerApps form and interact with the list directly.

 

You know your business need better than I do, but I would seriously examine the need to have all of those values in the same field. Unless PowerApps comes through with either of the solutions above, you might need to decide whether you want--integrity of your data in two fields or taking a risk in that integrity and having one field.

Highlighted

@Pn1995 actually, I wanted to thank you for pointing out this feature. I've never liked the choice with fill in options, because you could never really see all of the other - you'd probably have 12 different spellings of the same 'other' option. Now a user, if they need to use something not in the formal options, can at least pick the same spelling as someone else.

 

It doesn't change the actual definition of the choice field - it still has the original options you gave it. In the new/edit forms the options under the line are all the values that have been used in other items (if you clear those items up they don't show any more). Editing in quick edit mode doesn't show those 'others'.

 

I like it because now I can see what are common 'other' options and add those to the legal options.. So for me, it's a good feature. Understand if it doesn't work for everyone. I haven't tested that kind of field to see what PowerApps does to it, but I like how the standard forms work.