Parse JSON result didn't forward to next action

(0) Share

Report

Posted on by AchatesChen

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

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
AchatesChen 51 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AchatesChen 51 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

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,

Was this reply helpful? Yes No
AchatesChen 51 on at

Like (0)

Report
Copy link

Link copied!

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.
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.

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.

The last field to insert value, but no value.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AchatesChen ,

Please try this schema:

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

Best Regards,

Was this reply helpful? Yes No
AchatesChen 51 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No