How to validate Location Column in Sharepoint list?

%3CLINGO-SUB%20id%3D%22lingo-sub-3354403%22%20slang%3D%22en-US%22%3EHow%20to%20validate%20Location%20Column%20in%20Sharepoint%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3354403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20a%20conditional%20formula%20to%20validate%20data%20that%20is%20put%20in%20the%20location%20column%20to%20only%20accept%20valid%20street%20addresses.%20For%20instance%2C%20to%20prevent%20someone%20from%20putting%20an%20email%20address%20in%20the%20location%20column.%20The%20location%20column%20so%20far%20accepts%20the%20email%20address%20(or%20really%20any%20unrelated%20data)%20as%20a%20street%20address.%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-05-10%20at%203.24.42%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370613iAC0265C203CF55B3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-05-10%20at%203.24.42%20PM.png%22%20alt%3D%22Screen%20Shot%202022-05-10%20at%203.24.42%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3354403%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I need a conditional formula to validate data that is put in the location column to only accept valid street addresses. For instance, to prevent someone from putting an email address in the location column. The location column so far accepts the email address (or really any unrelated data) as a street address. Screen Shot 2022-05-10 at 3.24.42 PM.png

0 Replies