State names to USPS abbreviations

(0) Share

Report

Posted on by MasaYR

Hello,

I hope someone can help me here.

I am trying to convert/replace state name to abbreviation in power automate.

Here is my goal. I get form submission which contains state name. I would like to convert whatever the state name I get from form submission to abbreviation.

For example, someone submit form with state name "California": I would like to convert that answer to "CA", and use that field with "create item" in sharepoint action.

Is there any way to achieve this?

Thank you in advance!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Chriddle 8,441 Super User 2025 Season 2 on at

Like (3)

Report
Create a Compose ('Compose-Abbreviation') with the following object:

{ "Alabama": "AL", "Alaska": "AK", "American Samoa": "AS", "Arizona": "AZ", "Arkansas": "AR", "California": "CA", "Colorado": "CO", "Connecticut": "CT", "Delaware": "DE", "District Of Columbia": "DC", "Federated States Of Micronesia": "FM", "Florida": "FL", "Georgia": "GA", "Guam": "GU", "Hawaii": "HI", "Idaho": "ID", "Illinois": "IL", "Indiana": "IN", "Iowa": "IA", "Kansas": "KS", "Kentucky": "KY", "Louisiana": "LA", "Maine": "ME", "Marshall Islands": "MH", "Maryland": "MD", "Massachusetts": "MA", "Michigan": "MI", "Minnesota": "MN", "Mississippi": "MS", "Missouri": "MO", "Montana": "MT", "Nebraska": "NE", "Nevada": "NV", "New Hampshire": "NH", "New Jersey": "NJ", "New Mexico": "NM", "New York": "NY", "North Carolina": "NC", "North Dakota": "ND", "Northern Mariana Islands": "MP", "Ohio": "OH", "Oklahoma": "OK", "Oregon": "OR", "Palau": "PW", "Pennsylvania": "PA", "Puerto Rico": "PR", "Rhode Island": "RI", "South Carolina": "SC", "South Dakota": "SD", "Tennessee": "TN", "Texas": "TX", "Utah": "UT", "Vermont": "VT", "Virgin Islands": "VI", "Virginia": "VA", "Washington": "WA", "West Virginia": "WV", "Wisconsin": "WI", "Wyoming": "WY" }

Use it with an expression like this:

outputs('Compose-Abbreviation')['California']

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Chriddle,

Brillant!

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No