Update sheet updates wrong cell

(JaE) #1

I have a simple 2 column spreadsheet that updates from a flow that I have.
the flow is basically to keep track of “points”
the 2 columns are slack id and points
if a user triggers the flow for the first time it adds their slack id to the 1st column and 1 point to the 2nd column.
but if they user triggers it a second time it is supposed to just update the 2nd column but it is also updating the slack id in column 1. the update is unusual as it just changes the < and > in the slack id to “& lt;” and “& gt;” (minus the spaces) but that breaks everything and I have no idea why it’s happening.
any ideas?

(Karen Barker) #2

Hi there,

Unfortunately it looks like there’s some formatting that converts the special characters to the HTML name when the row is updated. The only workaround here would be to strip the < and > characters out of the slack ID before searching/adding/updating the value in google sheets. :disappointed: