Logic app, parse output from nested logic app to get value

Question

Logic app, parse output from nested logic app to get value

MyAzQuery 171

i am calling second logic app , from my first logic app. The output i receive from the nested logic app is as below.

User's image

i want to capture the "RETURN_VALUE" output using a variable. What expresssion can i use there ?

Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-11T00:07:36.0266667+00:00

@MyAzQuery Following up here to see if the response here helps

1 answer

Your answer

Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-11T00:07:36.0266667+00:00

@MyAzQuery Following up here to see if the response here helps

Answer 1

Pramod Valavala 20,656 Microsoft Employee Moderator

@MyAzQuery If the schema of the nested logic is going to be the same for all invocations, then a simple expression like below should work

@body('NestedLogicAppAction')['ResultSets']['Table1'][0]['RETURN_VALUE']

You can read more about expressions and operators supported in the official docs.

But if it is possible to get multiple responses (like more tables), then you could use the Parse JSON action to get tokens for the RETURN_VALUE, which when used in the logic apps designed should automatically add a for loop for you to process each table response accordingly.

MyAzQuery 171 Reputation points

2023-09-27T05:36:40.7466667+00:00

it is giving invalid expression

body('my-another-logic-app-actionname')['ResultSets']['Table1'][0]['RETURN_VALUE']
MyAzQuery 171 Reputation points

2023-09-27T05:37:20.72+00:00

it is giving invalid expression

body('my-another-logic-app-actionname')['ResultSets']['Table1'][0]['RETURN_VALUE']

Please help with correct value
Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-04T22:03:09.6+00:00
@MyAzQuery Apologies for the delay here! I've just tried out the exact expression and can confirm it works.

There are a few things you could check

Ensure the payload is valid JSON

Ensure the Content-Type header returned from the logic app is set to application/json

If the payload is double serialized (stringified JSON), try using the json function like so

json(body('NestedLogicAppAction'))['ResultSets']['Table1'][0]['RETURN_VALUE']

If none of these help, please do share your complete workflow here (removing any sensitive information) to better understand your workflow.

Share via

Logic app, parse output from nested logic app to get value

1 answer

Your answer