I am unsure why my reference action is not firing as all my other ones are firing as intended with similar logic. I have a Batches table with with a virtual VOLUME column based on referenced brews(we produce beer with multiple brews going into one batch) which is [Related Brews][BrewVolume] I also have a occupancy table for easy viewing of the current state of tanks and which batches are currently inside them that I update using workflows.
It is my understanding that I should be able to trigger a workflow based on a virtual column update. I.E when I add a brew instead of triggering the workflow on ADDS_ONLY for the Brews table I can trigger it on a UPDATE_ONLY for the batches volume virtual column.
I’ve tested the action which updates the occupancy tables volume and it works fine. But my reference action GetToSetNewVolume for Batches is not triggering. It’s formula for referenced rows is SELECT(Occupancy[BatchNo_ID], [BatchNo_ID] = [BatchNo]) which in the expression builder translates to “The list of values of column ‘BatchNo_ID’
…from rows of table ‘OCCUPANCY’
…where this condition is true: ((The value of column ‘BatchNo_ID’) is equal to (The value of column ‘BatchNo’))” If I test this expression it seems like it should work but it just isn’t. Any help would be appreciated greatly