I have an app with a trigger “When column changes” and a custom action. The first thing I do in the custom action is checking if the new column value already exists in the specified column, using the query items_by_column_values.
The weird thing is that sometimes it returns the itemId of the item that has been changed, but at other times it does not. Does anyone know if the trigger fires before or after the column value has been changed, currently it looks it is arbitrary (sometimes the new column value is found [like the trigger is fired after the column update] and sometimes it is not found [like the trigger is fired before the column update])
In my code I use await to wait for the promise, so my code is not asynchronous. It is very well possible that monday itself is asynchronous and you can’t rely when the trigger is fired.