Building out a flow the picks up a webhook from an internal database to populate a word template. The word template requires one field to have US State abbreviations and the other requires the full state name. The issue with the database is all States are stored as abbreviations and I cannot get into the DB to write a switch. Trying to do it it with the below nested if statement. Getting an error when trying to run - Any help would be very helpful.
if(contains(triggerBody()?['State'],'AL'),'Alabama',if(contains(triggerBody()?['State'],'AZ'),'Arizona'),if(contains(triggerBody()?['State'],'AR'),'Arkansas',if(contains(triggerBody()?['State'],'CA'),'California',if(contains(triggerBody()?['State'],'CO'),'Colorado',if(contains(triggerBody()?['State'],'CT'),'Connecticut',if(Contains(triggerBody()?['EntityState'],'DE'),'Delaware',if(contains(triggerBody()?['State'],'DC'),'District of Columbia',if(contains(triggerBody()?['State'],'FL'),'Florida',if(Contains(triggerBody()?['State'],'GA'),'Georgia',if(contains(triggerBody()?['State'],'HI'),'Hawaii',if(contains(triggerBody()?['State'],'ID'),'Idaho',if(Contains(triggerBody()?['State'],'IL'),'Illinois',if(contains(triggerBody()?['State'],'IN'),'Indiana',if(contains(triggerBody()?['State'],'IA'),'Iowa',if(contains(triggerBody()?['State'],'KS'),'Kansas',if(contains(triggerBody()?['State'],'KY'),'Kentucky',if(contains(triggerBody()?['State'],'LA'),'Louisina',if(contains(triggerBody()?['State'],'ME'),'Maine',if(contains(triggerBody()?['State'],'MD'),'Maryland',if(contains(triggerBody()?['State'],'MA'),'Massachusetts',if(contains(triggerBody()?['State'],'MI'),'Michigan',if(contains(triggerBody()?['State'],'MN'),'Minnesota',if(contains(triggerBody()?['State'],'MS'),'Mississippi',if(contains(triggerBody()?['State'],'MO'),'Missouri',if(contains(triggerBody()?['State'],'MT'),'Montana',if(contains(triggerBody()?['State'],'NE'),'Nebraska',if(contains(triggerBody()?['State'],'NV'),'Nevada',if(contains(triggerBody()?['State'],'NH'),'New Hampshire',if(contains(triggerBody()?['State'],'NJ'),'New Jersey',if(contains(triggerBody()?['State'],'NM'),'New Mexico',if(contains(triggerBody()?['State'],'NY'),'New York',if(contains(triggerBody()?['State'],'NC'),'North Carolina',if(contains(triggerBody()?['State'],'ND'),'North Dakota',if(contains(triggerBody()?['State'],'OH'),'Ohio',if(contains(triggerBody()?['State'],'OK'),'Oklahoma',if(contains(triggerBody()?['State'],'OR'),'Oregon',if(contians(triggerBody()?['State'],'PA'),'Pennsylvania',if(contains(triggerBody()?['State'],'RI'),'Rhode Island',if(contains(triggerBody()?['State'],'SC'),'South Carolina',if(contains(triggerBody()?['State'],'SD'),'South Dakota',if(contains(triggerBody()?['State'],'TN'),'Tennessee',if(contains(triggerBody()?['State'],'TX'),'Texas',if(contains(triggerBody()?['State'],'UT'),'Utah',if(contains(triggerBody()?['State'],'VT'),'Vermont',if(contains(triggerBody()?['State'],'VA'),'Virginia',if(contains(triggerBody()?['State'],'VA'),'Virginia',if(contains(triggerBody()?['State'],'WA'),'Washington',if(contains(triggerBody()?['State'],'WV'),'West Virginia',if(contains(triggerBody()?['State'],'WI'),'Wisconsin',if(contains(triggerBody()?['State'],'WY'),'Wyoming',''))))))))))))))))))))))))))))))))))))))))))))))))),'')
