Logic App Std For Each Loop Changing Valid true boolean to Invalid True

Question

Logic App Std For Each Loop Changing Valid true boolean to Invalid True

Warren Kinley 61

I have a simple Logic App standard workflow:

A boolean value retrieved from the table is the valid JSON values true/false, until within the "For each" loop, where it becomes True/False - invalid JSON.

[Output] Get resubmission details = "Resubmission": true,
[Output] Parse table entries = "Resubmission": true,
[Input] For each resubmission entry... = "Resubmission": True,

Is this a Logic App bug or a misunderstanding?

I have now discovered where the issue lays. When the workflow is initially deployed via devops the run fails since the "Compose" action does not recognise that the input is json, the designer shows the input not formatted and in black text:

I added a space to the "Compose" action and updated in the portal designer, now I see that the input to the action is now valid json (beautified):

What is wrong when the deployment occurs?

It seems the deployment code view includes the escaped characters:

{  
    "inputs": "{\n  \"Resolution\": \"@{items('For_each_resubmission_entry_on_table')?['Resolution']}\",\n  \"Resubmission\": @{items('For_each_resubmission_entry_on_table')?['Resubmission']},\n  \"SourceSystem\": \"@{items('For_each_resubmission_entry_on_table')?['SourceSystem']}\",\n  \"ValueType\": \"@{items('For_each_resubmission_entry_on_table')?['ValueType']}\",\n  \"DestinationSystem\": \"@{items('For_each_resubmission_entry_on_table')?['DestinationSystem']}\",\n  \"TimeUnit\": \"HOUR\",\n  \"StartTimeOffset\": @{items('For_each_resubmission_entry_on_table')?['StartTimeOffset']},\n  \"StopTimeOffset\": @{items('For_each_resubmission_entry_on_table')?['StopTimeOffset']}\n}"  
}

And once an arbitrary update in the portal is done:

{  
    "inputs": {  
        "DestinationSystem": "@{items('For_each_resubmission_entry_on_table')?['DestinationSystem']}",  
        "Resolution": "@{items('For_each_resubmission_entry_on_table')?['Resolution']}",  
        "Resubmission": "@items('For_each_resubmission_entry_on_table')?['Resubmission']",  
        "SourceSystem": "@{items('For_each_resubmission_entry_on_table')?['SourceSystem']}",  
        "StartTimeOffset": "@items('For_each_resubmission_entry_on_table')?['StartTimeOffset']",  
        "StopTimeOffset": "@items('For_each_resubmission_entry_on_table')?['StopTimeOffset']",  
        "TimeUnit": "HOUR",  
        "ValueType": "@{items('For_each_resubmission_entry_on_table')?['ValueType']}"  
    }  
}

MayankBargali-MSFT 70,936 Reputation points Moderator

2022-12-19T12:21:03.86+00:00

@Anonymous Thanks for reaching out. Please share the sample example of your Parse Table entities and what value you are specifying in your foreach action. It looks like you are using the Parse JSON action
and leveraging the Resubmission property with a condition and then using other property which is of type array in your foreach action?

Warren Kinley 61

No I am only parsing the data from the storage table and looping on each entity...

Attached the "Parse table entities" output as .txt since .json not allowed:
272132-parse-table-entities-output.txt

This is the code view for the "For each" loop:

"For_each_resubmission_entry_on_table": {  
                "actions": {  
                                   ...  
                },  
                "foreach": "@body('Parse_table_entities')?['entities']",  
                "runAfter": {  
                    "Parse_table_entities": [  
                        "Succeeded"  
                    ]  
                },  
                "runtimeConfiguration": {  
                    "concurrency": {  
                        "repetitions": 1  
                    }  
                },  
                "type": "Foreach"  
            },

MayankBargali-MSFT 70,936 Reputation points Moderator

2022-12-19T13:15:06.633+00:00

@Anonymous Thanks for sharing the sample data. Can you share more details in which action you are facing the issue and how you have confirmed that property Resubmission value has become invalid inside the foreach loop.
Warren Kinley 61 Reputation points

2022-12-19T13:26:08.07+00:00

So you can see from the json above from the output of the parse action that the "Resubmission" boolean has a valid json bool value of "true". Within the for each loop the first action, "Generate request from table entity", the value of "Resubmission" has been changed to "True" which is an invalid json value:
Warren Kinley 61 Reputation points

2022-12-21T10:08:01.017+00:00

The Logic App was deployed using Visual Code and the designer in here added the escape characters. I have removed all formatting from the Compose action and now the deployment is working straight away.

Accepted answer

1 additional answer

Your answer

MayankBargali-MSFT 70,936 Reputation points Moderator

2022-12-19T12:21:03.86+00:00

@Anonymous Thanks for reaching out. Please share the sample example of your Parse Table entities and what value you are specifying in your foreach action. It looks like you are using the Parse JSON action
and leveraging the Resubmission property with a condition and then using other property which is of type array in your foreach action?
Warren Kinley 61 Reputation points

2022-12-19T12:30:25.503+00:00

No I am only parsing the data from the storage table and looping on each entity...

Attached the "Parse table entities" output as .txt since .json not allowed:
272132-parse-table-entities-output.txt

This is the code view for the "For each" loop:

"For_each_resubmission_entry_on_table": { "actions": { ... }, "foreach": "@body('Parse_table_entities')?['entities']", "runAfter": { "Parse_table_entities": [ "Succeeded" ] }, "runtimeConfiguration": { "concurrency": { "repetitions": 1 } }, "type": "Foreach" },
MayankBargali-MSFT 70,936 Reputation points Moderator

2022-12-19T13:15:06.633+00:00

@Anonymous Thanks for sharing the sample data. Can you share more details in which action you are facing the issue and how you have confirmed that property Resubmission value has become invalid inside the foreach loop.
Warren Kinley 61 Reputation points

2022-12-19T13:26:08.07+00:00

So you can see from the json above from the output of the parse action that the "Resubmission" boolean has a valid json bool value of "true". Within the for each loop the first action, "Generate request from table entity", the value of "Resubmission" has been changed to "True" which is an invalid json value:
Warren Kinley 61 Reputation points

2022-12-21T10:08:01.017+00:00

The Logic App was deployed using Visual Code and the designer in here added the escape characters. I have removed all formatting from the Compose action and now the deployment is working straight away.

Answer 1

@Anonymous Thanks for sharing the details. I am not sure why you are again doing Parse JSON inside the for each loop. The value is already tokenized, and it should be available inside your foreach. Whatever schema that you have defined in your Parse JSON action the tokenized field will be changed accordingly. I have used the below schema in my Parse JSON action and define
Resubmission of type boolean. I am defining the entities value to my parse JSON.

{  
    "items": {  
        "properties": {  
            "DestinationSystem": {  
                "type": "string"  
            },  
            "PartitionKey": {  
                "type": "string"  
            },  
            "Resolution": {  
                "type": "string"  
            },  
            "Resubmission": {  
                "type": "boolean"  
            },  
            "RowKey": {  
                "type": "string"  
            },  
            "SourceSystem": {  
                "type": "string"  
            },  
            "StartTimeOffset": {  
                "type": "integer"  
            },  
            "StopTimeOffset": {  
                "type": "integer"  
            },  
            "Timestamp": {  
                "type": "string"  
            },  
            "ValueType": {  
                "type": "string"  
            },  
            "odata.etag": {  
                "type": "string"  
            }  
        },  
        "required": [  
            "DestinationSystem",  
            "PartitionKey",  
            "Resolution",  
            "Resubmission",  
            "RowKey",  
            "SourceSystem",  
            "StartTimeOffset",  
            "StopTimeOffset",  
            "Timestamp",  
            "ValueType",  
            "odata.etag"  
        ],  
        "type": "object"  
    },  
    "type": "array"  
}

The output is parsed as per my schema that I have defined in my outside and inside the loop Parse JSON action. Please validate the schema at your end and if you still observe the issue then please share your schema.

Warren Kinley 61 Reputation points

2022-12-19T14:22:46.963+00:00

I added a new variable to the workflow and now the run is working?!?!?!? I did not change anything a part from Initializing a new variable.
Warren Kinley 61 Reputation points

2022-12-20T08:21:53.653+00:00

This is how I have it in my workflow, but will accept this answer since this is what works now for me. It is just weird I was seeing this transformation from true to True before I updated the workflow in the portal arbitrarily.

Answer 2

Hi, for some reason I cannot comment against your answer... I am not doing a parse json inside my foreach loop, only a "Compose" then an "AppendToStringVariable":

"actions": {  
                    "Add_resubmission_to_request_body": {  
                        "inputs": {  
                            "name": "ResubmissionRequestBody",  
                            "value": "@concat(outputs('Generate_request_from_table_entity'),',')"  
                        },  
                        "runAfter": {  
                            "Generate_request_from_table_entity": [  
                                "Succeeded"  
                            ]  
                        },  
                        "type": "AppendToStringVariable"  
                    },  
                    "Generate_request_from_table_entity": {  
                        "inputs": "{\n  \"Resolution\": \"@{items('For_each_resubmission_entry_on_table')?['Resolution']}\",\n  \"Resubmission\": @{items('For_each_resubmission_entry_on_table')?['Resubmission']},\n  \"SourceSystem\": \"@{items('For_each_resubmission_entry_on_table')?['SourceSystem']}\",\n  \"ValueType\": \"@{items('For_each_resubmission_entry_on_table')?['ValueType']}\",\n  \"DestinationSystem\": \"@{items('For_each_resubmission_entry_on_table')?['DestinationSystem']}\",\n  \"TimeUnit\": \"HOUR\",\n  \"StartTimeOffset\": @{items('For_each_resubmission_entry_on_table')?['StartTimeOffset']},\n  \"StopTimeOffset\": @{items('For_each_resubmission_entry_on_table')?['StopTimeOffset']}\n}",  
                        "runAfter": {},  
                        "type": "Compose"  
                    }  
                }

Share via

Logic App Std For Each Loop Changing Valid true boolean to Invalid True

1 additional answer

Your answer