Location Column Country showing multiple values for same Country

%3CLINGO-SUB%20id%3D%22lingo-sub-1890032%22%20slang%3D%22en-US%22%3ELocation%20Column%20Country%20showing%20multiple%20values%20for%20same%20Country%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1890032%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20an%20issue%20using%20the%20Location%20column%20that%20it%20is%20showing%20different%20values%20for%20the%20same%20Country.%20I%20have%20a%20list%20of%20200%2B%20venues%2C%20mainly%20in%20the%20UK%20but%20some%20are%20being%20displayed%20as%20GB%20and%20some%20are%20being%20displayed%20as%20United%20Kingdom%20in%20the%20Location%20Column%20%3A%20Country%2C%20this%20is%20causing%20some%20issues%20when%20displaying%20this%20in%20powerapps%20as%20the%20filter%20functions%20then%20have%20two%20values%20for%20the%20same%20place.%20Is%20there%20a%20way%20to%20format%20the%20column%20to%20always%20be%20United%20Kingdom%3F%26nbsp%3B%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-1890032%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
Occasional Contributor

Hi,

 

I'm having an issue using the Location column that it is showing different values for the same Country. I have a list of 200+ venues, mainly in the UK but some are being displayed as GB and some are being displayed as United Kingdom in the Location Column : Country, this is causing some issues when displaying this in powerapps as the filter functions then have two values for the same place. Is there a way to format the column to always be United Kingdom? 

 

Thanks

0 Replies