Variables Not Defined Error Message In Flow

[jonfarmer]

I have a flow which has some variables defined. Later on in the flow I change the value of the variable from it's initial value. Later on still in the flow I am trying to use this variable to update a dynamics 365 record but I am getting this error message when trying to save the Flow. 

Flow save failed with code 'InvalidVariableOperation' and message 'The inputs of workflow run action 'Update_a_row_3' of type 'OpenApiConnection' are not valid. The variable 'Download_Speed' must be initialized before it can be used inside action 'Update_a_row_3'.'.

I have initialized the variable so what is the issue here? To repeat a value is set on initializing the variable and it is changed earlier on in the flow. I totally confused by this error message. 

Can anyone help me?

Many thanks

Jon

[ManishSolanki]

Hi @jonfarmer 

I would request you to pls share the screenshot for looking into the issue.

Thanks & Regards

Manish Solanki

[jonfarmer]

Screenshot attached

[Matthy79]

And now we need the action where you initialized the variable. Check if the expression where you use the variable is spelled correctly.

[jonfarmer]

Hi

Here it is 

[Matthy79]

Have you checked if there is a space after the name?

[jonfarmer]

No space before or after the name

[Matthy79]

Can you share a screenshot from the whole flow and the peek code of "Update_a_row_3"?

Have you also tried to pick the value from the dynamic content again?

[jonfarmer]

[Matthy79]

I don't see the peek code of "Update_a_row_3". And you really should get rid of all those variables. Are you updating all the variables individually more than one time in this flow.

[jonfarmer]

The peek is the third image. All of the variables are needed in the flow.

[Matthy79]

If you hit the 3 dots you can click on peek code. Please select it and post here the code it shows.

[jonfarmer]

{

    "inputs": {

        "host": {

            "connectionName": "shared_commondataserviceforapps",

            "operationId": "UpdateRecord",

            "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps"

        },

        "parameters": {

            "entityName": "new_swsvoucherpropertieses",

            "recordId": "@items('Loop_Through_Voucher_Properties')?['new_swsvoucherpropertiesid']",

            "item/new_charityregistrationnumber": "@variables('Charity Number')",

            "item/new_companyregistrationnumber": "@variables('Company Number')",

            "item/new_currentspeeddown": "@items('Loop_Through_Voucher_Properties')?['new_currentspeeddown']",

            "item/new_currentspeedup": "@items('Loop_Through_Voucher_Properties')?['new_currentspeedup']",

            "item/new_email": "@outputs('Get_a_row_by_ID')?['body/new_emailaddress']",

            "item/new_firstname": "@outputs('Get_a_row_by_ID')?['body/new_firstname']",

            "item/new_lastname": "@outputs('Get_a_row_by_ID')?['body/new_lastname']",

            "item/new_telephonenumber": "@outputs('Get_a_row_by_ID')?['body/new_telephonenumber']",

            "item/new_typeofcustomer": "@outputs('Get_a_row_by_ID')?['body/new_prospecttype']",

            "item/new_uniquetaxreference": "@variables('UTR')",

            "item/new_vatregistered": "@variables('VAT Registration')",

            "item/new_vatregistrationnumber": "@variables('VAT')",

            "item/new_voucherstatus": 100000004

        },

        "authentication": "@parameters('$authentication')"

    },

    "metadata": {

        "operationMetadataId": "3622e70e-7e2f-4f37-9112-cfeefb84781b"

    }

}

[Matthy79]

The variable "Download_Speed" is not used inside of action "Update_a_row_3" so it seems that there is some kind of bug. Have you tried to delete the action "Update a row 3" and save the flow? If it is now possible to save the flow you can create your action again from blank. It is also possible that the error message points to the wrong action. Have you checked all other actions using variable "Download_Speed"?

[jonfarmer]

Apologies I had taken out the Download_Speed reference as I was unable to save the flow. The only place the variable is changed is in the section "Loop_Through_Answers" in there is a switch. Below you can see the relevant section of the switch. 

What I think is strange is when I click in a field in "Update_a_row_3" in the Dynamic Content only one variable is shown with no option to show more. Is this significant?

[jonfarmer]

Here is the peek code with the variables added in 

{

    "inputs": {

        "host": {

            "connectionName": "shared_commondataserviceforapps",

            "operationId": "UpdateRecord",

            "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps"

        },

        "parameters": {

            "entityName": "new_swsvoucherpropertieses",

            "recordId": "@items('Loop_Through_Voucher_Properties')?['new_swsvoucherpropertiesid']",

            "item/new_charityregistrationnumber": "@variables('Charity Number')",

            "item/new_companyregistrationnumber": "@variables('Company Number')",

            "item/new_currentspeeddown": "@variables('Download_Speed')",

            "item/new_currentspeedup": "@variables('Upload_Speed')",

            "item/new_email": "@outputs('Get_a_row_by_ID')?['body/new_emailaddress']",

            "item/new_firstname": "@outputs('Get_a_row_by_ID')?['body/new_firstname']",

            "item/new_lastname": "@outputs('Get_a_row_by_ID')?['body/new_lastname']",

            "item/new_telephonenumber": "@outputs('Get_a_row_by_ID')?['body/new_telephonenumber']",

            "item/new_typeofcustomer": "@outputs('Get_a_row_by_ID')?['body/new_prospecttype']",

            "item/new_uniquetaxreference": "@variables('UTR')",

            "item/new_vatregistered": "@variables('VAT Registration')",

            "item/new_vatregistrationnumber": "@variables('VAT')",

            "item/new_voucherstatus": 100000004

        },

        "authentication": "@parameters('$authentication')"

    },

    "metadata": {

        "operationMetadataId": "3622e70e-7e2f-4f37-9112-cfeefb84781b"

    }

}

[Matthy79 · Accepted solution]

It is very hard to say from here.

What happens if you use a compose action (assign the value of the variable there) right in front of update a row and use the compose output to update the data?

What column data type is "new_currentspeeddown"? Power Automate tries to recognise what you possibly want to insert from dynamic content. Sometimes they get it wrong and it is even hard to insert the correct value, but that seems not to be the case here.

[jonfarmer]

Using compose seems to have worked.