cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AchatesChen
Helper I
Helper I

Parse JSON result didn't forward to next action

I need your help to get me out.

I am using parse JSON to get info as below, and the outputs looks correct.

 
 
 

2020-05-22 08 04 57.png

but in the next action, the input value becomes null, therefore I only inserted empty value to excel file.

2020-05-22 08 05 46.png

 

Here is the flow. What is the problem? How to resolve it?

2020-05-22 08 06 17.png

1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @AchatesChen ,

 

Please try this schema:

 

{
    "type": "object",
    "properties": {
        "localeId": {
            "type": "string"
        },
        "localeName": {
            "type": "string"
        }
    }
}

 

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-bacao-msft
Community Support
Community Support

 

Hi @AchatesChen ,

 

Please check if the value of this field in the original data is empty.

Then check again if the output of Parse JSON is as expected.

 

In addition, you can insert a Compose action in the middle to output the localeName and see if the value is null.

 

If the problem persists, please expand Flow run history so that we can view more details.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Barry,

 

Thank you for your reply.

As you can see, it has value in the output of parse JSON step. And I am very sure that it has value.

If I put a plain text in the last step, it will be inserted to Excel, so last step looks also ok. Only think I doubt is how system is transferring the data between steps.

 

This is the first time I use community. I am not sure why I can't upload image when I replying a post, so sorry I am not able to share more info to you for the moment.

I tried Compose and Variable, but both same result. Maybe just because I am doing something wrong?

 

Actually I am updating a row of Excel table. I only want to update one column, but in the output, I can see all columns value. Looks like it retrieved all columns' data from that row and insert them back, since I didn't retrieve those data from preceding steps.

 

Hi @AchatesChen ,

 

Strangely, I have never had a similar experience when using Parse JSON.

 

You can refer to the following screenshot to upload the screenshot:

178.PNG

Besides, you could refer to the following article to get more usage of Parse JSON action:

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Barry!

 

I read through the post, but looks like it is irrelevant.

 

It is strange that with the same button, it was asking me to put a link for the picture, but now it ask me to upload.

Now you can see the screenshots.

2020-05-22 11 45 03.png

In the input part of "Update a row" action, the localeName is null, but it is existing in parse JSON. 

Looks like it is not getting value from above, but actually they are sequentially, and no each loop.

2020-05-22 11 45 41.png

 

Also in the outputs of "Update a row" action, those value are not coming from preceding step.

looks like this step will read data from excel then write back? 
so if this is true, then "parse JSON" step doesn't take any effect. 

On the other hand, I tried to put string "Test" in "Update a row" action, then it will be captured and inserted into excel.

2020-05-22 11 46 39.png

 

The last field to insert value, but no value.

2020-05-22 11 47 07.png

 

Hi @AchatesChen ,

 

Please try this schema:

 

{
    "type": "object",
    "properties": {
        "localeId": {
            "type": "string"
        },
        "localeName": {
            "type": "string"
        }
    }
}

 

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Now it is working! Thank you so much, Barry!

 

I made the mistake, and the body information is misleading me. Actually I forgot that the input string of parse JSON was changed, so the JSON should also be changed, but I didn't realize that.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (10,171)