web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Nested IF error -> ...
Power Automate
Unanswered

Nested IF error -> "The function was invoked with '5' parameter(s)"

(0) ShareShare
ReportReport
Posted on by 4

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',''))))))))))))))))))))))))))))))))))))))))))))))))),'')

Categories:
I have the same question (0)
  • Srini007 Profile Picture
    3,323 Super User 2025 Season 2 on at

    Hi @chandlerhmf 

     

    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()?['State'],'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'),'Louisiana',
    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(contains(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'],'WA'),'Washington',
    if(contains(triggerBody()?['State'],'WV'),'West Virginia',
    if(contains(triggerBody()?['State'],'WI'),'Wisconsin',
    if(contains(triggerBody()?['State'],'WY'),'Wyoming',''))))))))))))))))))))))))))))))))))))))))))))))))))

     

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Thanks,

    Srini

  • chandlerhmf Profile Picture
    4 on at

    Hi! Thank you. This seems to have improved it but now the error states  "The function was invoked with '4' parameter(s)" as opposed to '5'

     

    Anything else I should edit? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard