Answered

SELECTED VALUES FROM PARSE JSON ARE NULL

(0) Share

Report

Posted on by JackBauwer

Hello everyone,

please I would like some help to finalize an automation, which copies data from a new table in excel (created by poweratumate) and updates the data in an existing another table.

When I select the data, the result is "null" and in the Parse Json input there is data to be compiled.

What am I doing wrong?

See the flow:

Now the results:

The selected outputs are null.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Botaverse 90 on at

Like (0)

Report
Copy link

Link copied!

Hi Mate,

If the flow finishes successfully , Try replicating same as Parse json highlighted field in Select activity.

If that helps, accept my reply as solution.

Was this reply helpful? Yes No
JackBauwer 12 on at

Like (0)

Report
Copy link

Link copied!

Did not help.
When I update the column values using Parse Json, it updates the value number ID=1 from table1 in all cells of the parent table.
Then it updates the ID=2 value for all cells in the same column.

Was this reply helpful? Yes No
Verified answer

JackBauwer 12 on at

Like (0)

Report
Copy link

Link copied!

I managed to make it work!
The problem was in the name of the columns, when I changed the column name of the "child" file to ID, and put the same column name of the "mother" file, it started to compile the data correctly!
Then I made a filter to consider only values above zero.
Now it's just wins!
Thanks for the answer!

Was this reply helpful? Yes No