Share feedback, ideas and get community help

Updated 8 months ago

Sheets: To add a new row if value does not exist

At a glance

The community member is trying to check if a specific {data} exists in a column, and if it does, update the row, and if not, add a new row. They encountered an error when trying to map the data to a "conditions' block. The comments suggest that the error does not actually occur, and that the flow should continue correctly. The community members recommend adding a condition block to check if the variable is empty or not.

Hi @Baptiste...

How can we check if {data} exists in a specific column?

If exists = update row

If don't exist = add new row

When I try to get data from sheet mapping {data} to a specific column, it returned an error which I cannot map to a "conditions' block.
Attachment
image.png
B
3 comments
It does not returns an error
It should continue the flow correctly
So you can just add a condition block on any variable to check if it's empty or not
Add a reply
Sign up and join the conversation on Discord