using an Automation I want to loop through a field (PLANT) and generate a report for each field value. This is working so far. Anyway now I want to distribute these plant-specific reports to certain users. For support I have added a table to my model looking like this
Plant ID
Mail
PLANT A
test@mail.com
PLANT A
new_test@mail.com
PLANT B
report@mail.com
When looping through the Plants I would also expect that I can tell the automation to use only the associated values from the field "Mail". I tried a variable that I created in the script but this doesn't work. Anyone can help?
