SOLVED

Restrict SharePoint list column/field to upper case only

%3CLINGO-SUB%20id%3D%22lingo-sub-1417785%22%20slang%3D%22en-US%22%3ERestrict%20SharePoint%20list%20column%2Ffield%20to%20upper%20case%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417785%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20restrict%20a%20SharePoint%20list%20column%2Ffield%20to%20only%20accept%20upper%20case%20text%20characters%20as%20input%3F%20I%20have%20found%20one%20formula%20for%20this%20online%20but%20it%20wants%20to%20apply%20it%20per%20character%20-%20the%20amount%20of%20characters%20for%20my%20input%20may%20vary%2C%20so%20I'm%20hoping%20to%20apply%20a%20formula%20to%20the%20whole%20field%20rather%20than%20per%20character.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1417785%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-1418336%22%20slang%3D%22en-US%22%3ERe%3A%20Restrict%20SharePoint%20list%20column%2Ffield%20to%20upper%20case%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292006%22%20target%3D%22_blank%22%3E%40Rhiheu%3C%2FA%3E%26nbsp%3Bif%20you%20use%20a%20customised%20Power%20Apps%20form%20for%20your%20list%20instead%20of%20the%20default%20SharePoint%20form%20then%20you%20can%20certainly%20do%20this%20quite%20easily.%20Either%20have%20a%20text%20input%20field%20which%20will%20convert%20what%20the%20user%20types%20to%20upper%20case.%20Or%20convert%20it%20to%20upper%20case%20when%20it's%20saved%20to%20the%20list%20which%20is%20the%20way%20I've%20done%20it%20in%20the%20attached%20video.%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%20image-alt%3D%22upper.png%22%20style%3D%22width%3A%20452px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194470iFE7A065CA30D2C13%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22upper.png%22%20alt%3D%22upper.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%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22upper.gif%22%20style%3D%22width%3A%20701px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194467i1C0639FD44A6877B%2Fimage-dimensions%2F701x412%3Fv%3D1.0%22%20width%3D%22701%22%20height%3D%22412%22%20title%3D%22upper.gif%22%20alt%3D%22upper.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420022%22%20slang%3D%22en-US%22%3ERe%3A%20Restrict%20SharePoint%20list%20column%2Ffield%20to%20upper%20case%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420022%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%2C%20thanks%20for%20your%20reply.%20Unfortunately%20users%20will%20not%20be%20inputting%20items%20directly%20in%20SharePoint%20to%20this%20list%20-%20new%20items%20are%20received%20via%20a%20Graph%20API%20integration%20-%20I've%20actually%20disabled%20the%20ability%20for%20users%20to%20use%20the%20'New'%20item%20form%20altogether.%20The%20Graph%20API%20integration%20is%20all%20set%20up%20and%20working%2C%20I'm%20just%20hoping%20to%20make%20it%20error%20and%20fail%20if%20it%20tries%20to%20send%20anything%20in%20lower%20case.%20It's%20error%20report%20will%20then%20flag%20to%20admin%20users%20to%20explore%20the%20incorrectly-configured%20entry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420115%22%20slang%3D%22en-US%22%3ERe%3A%20Restrict%20SharePoint%20list%20column%2Ffield%20to%20upper%20case%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420115%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292006%22%20target%3D%22_blank%22%3E%40rhiheu1%3C%2FA%3E%26nbsp%3Bah%20ok%2C%20not%20sure%20I%20can%20help%20you%20then.%20(PS%20my%20daughter%20is%20also%20called%20Rhiannon%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%20)%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%3CLINGO-SUB%20id%3D%22lingo-sub-1439496%22%20slang%3D%22en-US%22%3ERe%3A%20Restrict%20SharePoint%20list%20column%2Ffield%20to%20upper%20case%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1439496%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BAh%20ok%20no%20worries%2C%20thanks%20anyway.%20Haha%20it's%20a%20great%20name%20%3AD%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

Hi,

Is it possible to restrict a SharePoint list column/field to only accept upper case text characters as input? I have found one formula for this online but it wants to apply it per character - the amount of characters for my input may vary, so I'm hoping to apply a formula to the whole field rather than per character.

Thanks.

4 Replies
Highlighted
Best Response
Solution

@Deleted if you use a customised Power Apps form for your list instead of the default SharePoint form then you can certainly do this quite easily. Either have a text input field which will convert what the user types to upper case. Or convert it to upper case when it's saved to the list which is the way I've done it in the attached video.

 

upper.png

 

 

upper.gif

 

Highlighted

Hi @Rob Elliott, thanks for your reply. Unfortunately users will not be inputting items directly in SharePoint to this list - new items are received via a Graph API integration - I've actually disabled the ability for users to use the 'New' item form altogether. The Graph API integration is all set up and working, I'm just hoping to make it error and fail if it tries to send anything in lower case. It's error report will then flag to admin users to explore the incorrectly-configured entry.

Highlighted

@Deleted ah ok, not sure I can help you then. (PS my daughter is also called Rhiannon :smile: )

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott Ah ok no worries, thanks anyway. Haha it's a great name :D