Add columns conditionally


Is there a way to add columns depending on whether they already exist?
I have complicated flow that results in table with variable number of columns. I need to add empty column Column1 if it is not in the table yet.

Thank you.

Hey @Gregory_Gugel!

You can use the Insert static text columns step and create Column1 as shown below:


Just make sure you check the box under the step’s Advanced Settings, and you should be good to go.

Additionally, you can create as many of these conditional columns as you’d like in this step.