I was wondering whether it was possible to update a field in current and past requests based on an asset value.
Our customers are logged as reporters. A flow automatically updates a field called 'department' with the department the reporter works at. It takes this value from our assets. It looks up the reporter in our assets and looks for the department value. For example: if I raise a request, it fills in my name in 'Reporter' and 'IT' in 'Department'.
However, I have recently created this automation rule, so all requests before that have a department value of 'none'. Is it possible to bulk update all these requests with the department value in our assets? I've tried something like {{reporter.Afdeling.Name}} but that doesn't work, it just shows exactly that: '{{reporter.Afdeling.Name}}'.
Does anyone have experience with this.
