I’m creating an automation that copy paste some fields in another when the requirements are made. I’ve got one problem and it’s with Multiple select fields or Link to table fields (only when it’s a many to one relationship). For the other fields it works perfectly but when I’m trying to insert more than one option with those fields, I usually receive this error : “The provided value should be a valid integer or string”.
It works when I select 0 > value but I wonder if i’m missing something or if it’s just not possible and I need to bypass it with an iteration ?
I think the problem is because you are not using an iterator as you suspected. Because the ... > [All] > ... > [All] > value is a list of list of values so it doesn’t become the just a list of values. You could use ... > [0] > ... > [All] > value but if you have multiple rows updated at the same time you’ll copy only the first row updated and ignore the rest.
With the iterator you can deal with every created rows one by one. Right now you aren’t copy pasting updated row to another row, your are copying multiple rows in one row and I don’t think that’s you want to do.
But if it’s with an iteration I don’t see how it will not rewrite the field.
I’m not sure I understand the question and what exactly you want to create, but you could first create the row outside of the iterator then add the iterator and update the previously create row if you want to have only one created row per rows update may be? Just keep in mind that you could have multiple rows updated at once so the payload of the “Rows updated” trigger is an array of created rows.
Feel free to share more details on what you are trying to achieve if my answer is not exactly what you would expect.
