Make a FIeld not required

%3CLINGO-SUB%20id%3D%22lingo-sub-1088194%22%20slang%3D%22en-US%22%3EMake%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1088194%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Sharepoint%20List%20name%20%22Delivery%20Orders%22%3C%2FP%3E%3CP%3EBut%20I%20have%20add%203%20content%20type%20to%20this%20List.%3C%2FP%3E%3CP%3E3%20Content%20Type%20have%20the%20List%20Content%20Type%20is%20the%20Parent%20Content%20type%20so%20that%20have%20Title%20Column.%3C%2FP%3E%3CP%3EI%20have%20set%20the%20Title%20Column%20in%203%20Content%20type%20to%20%3CSTRONG%3EOptional%3C%2FSTRONG%3E%20in%20both%20the%20%3CSTRONG%3ESite%20Content%20type%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EList%20Content%20type%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E3%20Site%20Content%20Type%20-%26gt%3B%20Title-%26gt%3B%20%3CSTRONG%3E%22Optional%22%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163758i7F68E4FF080B1C8B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202020-01-04%20at%2012.18.21%20PM.png%22%20title%3D%22Screen%20Shot%202020-01-04%20at%2012.18.21%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3%20List%20Content%20Type%20-%26gt%3B%20DO%20Number%20-%26gt%3B%20%3CSTRONG%3E%22Optional%22%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163761i9655386C0FF48523%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202020-01-04%20at%2012.18.09%20PM.png%22%20title%3D%22Screen%20Shot%202020-01-04%20at%2012.18.09%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163760iE9F6E6DF29CBA57E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202020-01-04%20at%2012.17.56%20PM.png%22%20title%3D%22Screen%20Shot%202020-01-04%20at%2012.17.56%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163759i1C38DBC154E21C7C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202020-01-04%20at%2012.17.41%20PM.png%22%20title%3D%22Screen%20Shot%202020-01-04%20at%2012.17.41%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF0000%22%3EBut%20when%20I%20finished%20the%20Form%2C%20it%20require%20me%20to%20fill%20the%20DO%20Number%20(that%20Title%20Column%20renamed)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163757iFEACE359F0A7C627%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202020-01-04%20at%2012.16.44%20PM.png%22%20title%3D%22Screen%20Shot%202020-01-04%20at%2012.16.44%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20that%3F%3C%2FP%3E%3CP%3EI%20can%20use%20PnP%20PowerShell%2C%20if%20you%20have%20script%20that%20change%20the%20Require%20Column%20-%26gt%3B%20non%20Require%20Column%2C%20please%20share%20to%20me.%3C%2FP%3E%3CP%3ENote%20that%3A%20This%20List%20have%20use%203%20Content%20Type.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1088194%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1088215%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1088215%22%20slang%3D%22en-US%22%3EEven%20thou%20the%20content%20types%20are%20set.%20You%20still%20need%20to%20go%20to%20the%20column%20itself%20in%20the%20columns%20section%20on%20the%20list%20settings%20and%20make%20it%20not%20required%20on%20the%20column%20settings.%20It%20overrides%20the%20content%20type.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1088273%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1088273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E.%20I%20click%20on%20the%20Column%20Field%20but%20no%20setting%20to%20make%20it%20not%20required.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163765i9FDCA11A6A4A8E96%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202020-01-04%20at%2012.00.14%20PM.png%22%20title%3D%22Screen%20Shot%202020-01-04%20at%2012.00.14%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20give%20me%20another%20advise%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1090778%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1090778%22%20slang%3D%22en-US%22%3EI%20don%E2%80%99t%20know%20if%20it%20matters%20or%20not.%20It%20you%20can%E2%80%99t%20have%20blank%20values%20and%20unique%20checked%20too%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1090796%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1090796%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BNo%2C%20I%20can't%20have%20blank%20value%2C%20It%20required.%20Please%20see%20the%20image%20above%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1090798%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1090798%22%20slang%3D%22en-US%22%3EYou%20have%20unique%20values%20checked.%20You%20can%E2%80%99t%20have%20blank%20values%20if%20this%20is%20Checked.%20Which%20means%20you%20have%20to%20put%20In%20a%20value.%20Aka%20required.%20I%20don%E2%80%99t%20think%20this%20is%20the%20issue%20but%20you%20won%E2%80%99t%20be%20able%20to%20not%20enter%20a%20value%20of%20unique%20is%20set%20because%20once%20someone%20enters%20one%20blank.%20The%20next%20blank%20is.l%20no%20longer%20unique.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1090799%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1090799%22%20slang%3D%22en-US%22%3EAlso%20what%20type%20of%20list%20did%20you%20create%20this%20from%3F%20Required%20should%20be%20an%20option%20from%20a%20custom%20list%20template.%20If%20you%20create%20a%20new%20list%20is%20the%20option%20there%20on%20the%20title%20column%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091065%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091065%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20matters%20to%20me.%20I%20want%20to%20set%20the%20ID%20of%20Order%20Number%20automatically%20from%20Power%20Apps%2C%20so%20it%20must%20be%20blank%20from%20start%20and%20fill%20up%20later.%3C%2FP%3E%3CP%3EI%20uncheck%20the%20%3CSTRONG%3E%22Enforce%20unique%20values%3A%26nbsp%3B%3CFONT%20size%3D%223%22%3E%26nbsp%3B%22%2C%20but%20nothing%20change!%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EIt's%20a%20bug%2C%20maybe%2C%20some%20list%20I%20have%20the%20same%20scenarios%20but%20it%20still%20works%2C%20but%20this%20list%20doesn't%20work.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091066%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091066%22%20slang%3D%22en-US%22%3EThat%E2%80%99s%20why%20I%20said%20what%20template%20did%20you%20use.%20If%20you%20used%20something%20other%20than%20the%20custom%20list%20it%20probabaly%20won%E2%80%99t%20allow%20it%20to%20be%20changed.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091288%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091288%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BI%20use%20Custom%20List%20template%2C%20I%20am%20sure%20about%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1092819%22%20slang%3D%22en-US%22%3ERe%3A%20Make%20a%20FIeld%20not%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1092819%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343214%22%20target%3D%22_blank%22%3E%40ca_rem%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20you%20enable%20content%20types%2C%20the%20required%20option%20moves%20from%20the%20list%20field%20to%20the%20content%20type.%20You'll%20have%20to%20open%20the%20content%20type%20and%20edit%20the%20required%2Foptional%2Fhidden%20choice%20for%20that%20field%20in%20each%20content%20type%20separately.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20complicate%20matters%20here%2C%20is%20the%20fact%20that%20you're%20DO%20number%20looks%20to%20be%20the%20default%20Title%20field.%20The%20Title%20field%20is%20an%20important%20field%20and%20you%20need%20to%20be%20careful%20with%20it%20as%20it%20is%20the%20main%20identifying%20field%20and%20it%20does%20behave%20a%20little%20bit%20differently%20from%20other%20fields.%20Keep%20in%20mind%20that%20this%20is%20the%20field%20people%20will%20click%20to%20open%20the%20item%20form%2C%20so%20leaving%20it%20blank%20is%20not%20a%20good%20best%20practice.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20fine%20to%20rename%20the%20Title%20field.%20I%20do%20it%20all%20the%20time.%20But%20the%20Title%20field%20is%20always%20required.%20If%20you%20need%20the%20DO%20number%20to%20be%20optional%2C%20I%20would%20either%20pick%20another%20field%20to%20use%20as%20the%20Title%20field%20or%20add%20a%20default%20value%20like%20%22Enter%20DO%20number%22.%20That%20way%20there%20is%20always%20a%20value%20(which%20fulfills%20the%20requirement)%20and%20it's%20a%20static%20value%20so%20easy%20to%20filter%20or%20program%20around.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a Sharepoint List name "Delivery Orders"

But I have add 3 content type to this List.

3 Content Type have the Item Content Type is the Parent Content type so that have Title Column.

I have set the Title Column in 3 Content type to Optional in both the Site Content type and List Content type.

3 Site Content Type -> Title-> "Optional":

Screen Shot 2020-01-04 at 12.18.21 PM.png

 

3 List Content Type -> DO Number -> "Optional":

Screen Shot 2020-01-04 at 12.18.09 PM.png

 

Screen Shot 2020-01-04 at 12.17.56 PM.png

 

Screen Shot 2020-01-04 at 12.17.41 PM.png

 

 

But when I finished the Form, it require me to fill the DO Number (that Title Column renamed)

Screen Shot 2020-01-04 at 12.16.44 PM.png

 

How can I fix that?

I can use PnP PowerShell, if you have script that change the Require Column -> non Require Column, please share to me.

Note that: This List have use 3 Content Type.

10 Replies
Even thou the content types are set. You still need to go to the column itself in the columns section on the list settings and make it not required on the column settings. It overrides the content type.

@Chris Webb. I click on the Column Field but no setting to make it not required. 

Screen Shot 2020-01-04 at 12.00.14 PM.png

 

Can you give me another advise?

I don’t know if it matters or not. It you can’t have blank values and unique checked too

@Chris Webb No, I can't have blank value, It required. Please see the image above

You have unique values checked. You can’t have blank values if this is Checked. Which means you have to put In a value. Aka required. I don’t think this is the issue but you won’t be able to not enter a value of unique is set because once someone enters one blank. The next blank is.l no longer unique.
Also what type of list did you create this from? Required should be an option from a custom list template. If you create a new list is the option there on the title column?

@Chris Webb 

It matters to me. I want to set the ID of Order Number automatically from Power Apps, so it must be blank from start and fill up later.

I uncheck the "Enforce unique values:  ", but nothing change!

It's a bug, maybe, some list I have the same scenarios but it still works, but this list doesn't work.

That’s why I said what template did you use. If you used something other than the custom list it probabaly won’t allow it to be changed.

@Chris Webb I use Custom List template, I am sure about that.

@ca_rem 

 

Once you enable content types, the required option moves from the list field to the content type. You'll have to open the content type and edit the required/optional/hidden choice for that field in each content type separately. 

 

To complicate matters here, is the fact that you're DO number looks to be the default Title field. The Title field is an important field and you need to be careful with it as it is the main identifying field and it does behave a little bit differently from other fields. Keep in mind that this is the field people will click to open the item form, so leaving it blank is not a good best practice.  

 

It's fine to rename the Title field. I do it all the time. But the Title field is always required. If you need the DO number to be optional, I would either pick another field to use as the Title field or add a default value like "Enter DO number". That way there is always a value (which fulfills the requirement) and it's a static value so easy to filter or program around.