I want to convert US States Full Names into Abbreviations

Hi Community,

I want to convert the fill name of the US states into Abbreviations (For instance, Maryland to MD and so forth). In the ‘state’ column, I want to see the abbreviations. Here is my sample input file. Can anyone help? Thanks!
InputFile_States.xlsx (9.7 KB)

One of many options:

Create a lookup dictionary eg. by JSON input:

if needed Swap name and state code

then use a or each row and change the statename to the state code

Hello @Sisay_Dinku

You can keep in an excel file or a json file and convert that to a dictionary.

Then use the country name as the key to get the abbreviation.



Could you put that in the flow? I could quite get it.

Can anyone help with this?

New Microsoft Excel Worksheet.xlsx (11.5 KB)
This is the excel sheet with states and its abbreviation
here is the workflow
Workflow.xaml (7.8 KB)

@sangeethaneelavannan1 Thank you for the dictionary. I want to make it clear that I want the abbreviations are expected to be written sate names in the State Sheet from the States_abbr sheet after the vlookup. I am attaching the example.
Sates_VlookUp.xlsx (17.0 KB)

@sangeethaneelavannan1 I use modern design

@Sisay_Dinku Workflow.xaml (10.6 KB)

@sangeethaneelavannan1 That was excellent. It has worked. I’ll mark this as a solution. Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.