Power Automate- Apply to each action not taking out of Parse Json

(0) Share

Report

Posted on by CU01120131-0

Hey, pls help me to understand what I'm doing wrong.

I'm building a flow to run a Power BI query and add the extracted data into a Dataverse table. The flow runs, but no data is added to the Dataverse table. Here are the steps:

Parse Json step seems to be giving an array as output, but the Apply to each action does not take the output of Parse Json.

Input to Parse Json action:

Output of parse json action:

Checking the input to Apply to each, I see this:

Pls help to fix the issue with this flow.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

developerAJ 4,741 on at

Like (0)

Report

could you please provide the input of loadnumber property in add a new row action

Was this reply helpful? Yes No
CU01120131-0 4 on at

Like (0)

Report

The data goes into a column called Load Number in the Dataverse table, and that column is defined as String.

Was this reply helpful? Yes No
chiaraalina 1,183 on at

Like (0)

Report

Hi

Can you show the input of your Add a new row action? Are you using an expression or direct dynamic content?

Was this reply helpful? Yes No
CU01120131-0 4 on at

Like (0)

Report

Here's the Schema for Parse Json action:

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "INBOUND_LOAD_ID": {

                "type": "string"

            },

            "SHIPPING_ORDER_NBR": {

                "type": "string"

            }

        },

        "required": [

            "INPUT_DATA[INBOUND_LOAD_ID]"

        ]

    }

}

Input to Apply to each is dynamic: body('Parse_JSON_2')

Was this reply helpful? Yes No
Suggested answer

developerAJ 4,741 on at

Like (0)

Report

{

    "type": "object",

    "properties": {

        "body": {

            "type": "array",

            "items": {

                "type": "object",

                "properties": {

                    "INPUT_DATA[INBOUND_LOAD_ID]": {

                        "type": "string"

                    },

                    "INPUT_DATA[SHIPPING_ORDER_NBR]": {

                        "type": "string"

                    }

                },

                "required": [

                    "INPUT_DATA[INBOUND_LOAD_ID]",

                    "INPUT_DATA[SHIPPING_ORDER_NBR]"

                ]

            }

        }

    }

}

try this schema not sure why parse Json was giving something different

your content and schema are not matching

Was this reply helpful? Yes No
developerAJ 4,741 on at

Like (0)

Report

Once you update your parse Json schema update the input property of Load Number

Was this reply helpful? Yes No
developerAJ 4,741 on at

Like (0)

Report

Following up to check whether the issue has been resolved. If it is resolved, please mark the thread as closed. If not, please tag me and provide info for further assistance.

Was this reply helpful? Yes No