I’m trying to update multiple rows. I have 4 columns from the original sheet and I want to update the column 5.
The values of the column 5 are in a previous array aggregator but when I run the update all the values in column 5 are together in a long string:
You have to pass the array of rows as follows:
If you want to keep aal the existing values as such and just want to change a single column values. You can map the values from the seach module in the array aggregator selecting the source module as " search module" and Target structure type as “bluk update rows”. See the below ss:
Here you can see I want to keep all the values in column 1,2, 4 and 5 the same and update the 3rd column with current date.
Feel free to reach out if you have further queries.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
In your example, I want to update the third column with an array. In my case is the column 5:
but the result is a concatenated value in all the rows:
The array that I’m trying to put is:
You can pass the value from iterator in the column 5 in array aggregator module instead of aggregating iterators value . Then pass the output array in bulk update module.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
See the sample here.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
If I put the bulk module after the iterator, Will It execute several times? I attached my blueprint.
blueprint (4).json (68.5 KB)
We have updated the flow as follows
Attaching the blueprint.
blueprint - 2025-04-28T115553.898.json (56.6 KB)
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
I did what you said, but when I bulk data in the excel rows were double. For example, I had two rows, so it generated two comments but in the iterator it resulted four values.
blueprint (7).json (66.6 KB)
