Conditional choice column - content types?

%3CLINGO-SUB%20id%3D%22lingo-sub-1884493%22%20slang%3D%22en-US%22%3EConditional%20choice%20column%20-%20content%20types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1884493%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20am%20building%20a%20helpdesk%20solution%20in%20SharePoint%20Online%20and%20have%20a%20choice%20column%20called%20%22Status%22%20and%20a%20resolution%20column%20that%20should%20be%20filled%20out%20when%20the%20status%20column%20equals%20%22Closed%22.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI've%20been%20asked%20to%20make%20the%20%22resolution%22%20column%20'required'%20-%20is%20this%20possible%20as%20at%20the%20moment%20we%20cant%20have%20it%20required%20as%20it%20asked%20to%20be%20filled%20out%20anytime%20when%20updating%20a%20ticket.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI'm%20thinking%20with%20content%20types%20this%20might%20be%20possible%3F%20But%20not%20sure%20how%20to%20go%20about%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EIdeally%20thinking%20that%20when%20the%20status%20column%20is%20changed%20to%20%22Closed%22%2C%20the%20%22Resolution%22%20field%20will%20appear%20then%20the%20user%20will%20have%20to%20fill%20this%20out%20as%20it%20will%20be%20required.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1884493%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-1887284%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20choice%20column%20-%20content%20types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F238684%22%20target%3D%22_blank%22%3E%40Chris%20Cundy%3C%2FA%3E%26nbsp%3Bother%20than%20having%20to%20change%20the%20content%20type%20when%20the%20item%20status%20would%20be%20closed%20is%20to%20convert%20the%20SharePoint%20form%20to%20a%20PowerApps%20form%20where%20you%20will%20be%20able%20to%20build%20the%20logic%20to%20display%20resolution%20only%20when%20status%20is%20closed%20(this%20would%20not%20require%20using%20different%20content%20types)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

I am building a helpdesk solution in SharePoint Online and have a choice column called "Status" and a resolution column that should be filled out when the status column equals "Closed".

I've been asked to make the "resolution" column 'required' - is this possible as at the moment we cant have it required as it asked to be filled out anytime when updating a ticket.

I'm thinking with content types this might be possible? But not sure how to go about this?

Ideally thinking that when the status column is changed to "Closed", the "Resolution" field will appear then the user will have to fill this out as it will be required.

Thoughts?

1 Reply

@Chris Cundy other than having to change the content type when the item status would be closed is to convert the SharePoint form to a PowerApps form where you will be able to build the logic to display resolution only when status is closed (this would not require using different content types)