Update Property In Array Of Objects

There is a trick that uses updatecdt to update any field in a CDT. The problem with updatecdt is that you cannot create a dictionary with dynamic key names. To do that you create a dictionary with a fixed key name, convert it to JSON, replace the key name with your dynamic name and convert it back to an Appian dictionary. Check the code below. There is one issue. JSON does not handly date and datetime values correctly. To get this you can convert date/datetime values to a decimal. Appian automatically converts a decimal back to a correct date/datetime.

a!fromJson(substitute(a!toJson({X_A_Z_Q_Y:local!valueExternal}), "X_A_Z_Q_Y", ri!name))

There is a trick that uses updatecdt to update any field in a CDT. The problem with updatecdt is that you cannot create a dictionary with dynamic key names. To do that you create a dictionary with a fixed key name, convert it to JSON, replace the key name with your dynamic name and convert it back to an Appian dictionary. Check the code below. There is one issue. JSON does not handly date and datetime values correctly. To get this you can convert date/datetime values to a decimal. Appian automatically converts a decimal back to a correct date/datetime.

a!fromJson(substitute(a!toJson({X_A_Z_Q_Y:local!valueExternal}), "X_A_Z_Q_Y", ri!name))