Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Power Automate - General Discussion / New Error in Power Aut...
Power Automate - General Discussion
Unanswered

New Error in Power Automate - Action 'Reformat_Assignee_Name' failed

(0) ShareShare
ReportReport
Posted on by TB-18091850-0
I have a Power Automate that I developed in Power Automate Classic. It has been running for over a year and was working 5 days ago. Today I tried to run the flow and the flow failed with the following error...

"Unable to process template language expressions in action 'Reformat_Assignee_Name' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#split for usage details.'." I have run a flow checker in edit mode and it shows no errors.

This is the code that it's trying to execute 
{
    "inputs": "@concat(split(outputs('Get_a_row')?['body/Assigned~1Engaged'], ' ')[0], ', ', slice(outputs('Get_a_row')?['body/Assigned~1Engaged'], add(indexOf(outputs('Get_a_row')?['body/Assigned~1Engaged'], ' '), 1)))",
    "metadata": {
        "operationMetadataId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
    }
}
 
Categories:
Process Advisor
  • CA1105 Profile Picture
    CA1105 129 on at
    New Error in Power Automate - Action 'Reformat_Assignee_Name' failed
    Seems like your Reformat_Assignee_Name value is coming as null. You can use expression suggested by EKarim.
  • Suggested answer
    EKarim Profile Picture
    EKarim 9,947 on at
    New Error in Power Automate - Action 'Reformat_Assignee_Name' failed
    It seems that the outputs('Get_a_row')?['body/Assigned~1Engaged'] contains no value, i.e. it is null.
     
    You could add a condition to check if outputs('Get_a_row')?['body/Assigned~1Engaged'] is not empty, and if it is not empty, perform the concat operation.
     
    Something similar to the following:
     
    {
    "inputs": if(
        equals(outputs('Get_a_row')?['body/Assigned~1Engaged'], null), 
        null, 
        concat(
            split(outputs('Get_a_row')?['body/Assigned~1Engaged'], ' ')[0], 
            ', ', 
            slice(
                outputs('Get_a_row')?['body/Assigned~1Engaged'], 
                add(
                    indexOf(outputs('Get_a_row')?['body/Assigned~1Engaged'], ' '), 
                    1
                )
            )
        )
    ),
    "metadata": {
        "operationMetadataId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
    }
}
     
    Ellis

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,749

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans