I have a button that generates a random row value based on the size of a table:
ModifyRows(row, row.value, RoundUp(Product(table.Count(), Random()), 0))
When I push the button it works perfectly and updates the value.
However, if I set an automation to have that formula action, it fails. I thought maybe disintermediating with a button would work, so I created a button that has this action, and set an automation to push the button. It fails too - and by saying it fails I mean the automation runs, but it always results in the same value. When I manually push the button, it generates a proper random value and updates. Ideas why it only works manually?