Answered

Compare sheets to JSON and add new data

(0) Share

Report

Posted on by Marloes1

Hi,

I made a flow where I get all rows from Google Sheets and use select to get only the 'Value Perioden' column. Then I want to compare it with my JSON file. If there is a new 'Perioden' in the JSON file I want to add it to the Sheet.

Unfortunately, my condition always gives 'false' and all items in the JSON file end up in the Sheet. Can somebody help me with what goes wrong?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Marloes1

Pls create a simple array using Select action instead of object array. You need to modify the Select action as mentioned below:

Click 'Switch map to text mode' button on the right of Map property:

Next, choose the required column from the dynamic content. In this example, I have chosen 'product' column but replace it with actual column as per your need:

Pls retest the flow after modifying Select action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Marloes1 4 on at

Like (0)

Report

yes, it works @ManishSolanki! Thanks a lot

Was this reply helpful? Yes No